I’m currently trying split data again from a column and having a bit of trouble with the regex split node again. I understand the first part of the code might be ([0-9]{4}) , but having a bit of trouble with the text since it also contains - and &.
Current Data
1234 ABCD EECKD 123.4562.1234.2142.6378.000.0000 -30.00 30.00 0.00
5678 ABCDE - FGHIK 123.4562.0000.2411.0000.000.0000 0.00 -12,345.86 -10,412.86
3143 ABC - DEFKHDF 213.4562.0000.2445.0000.000.0000 12,345,678.90 227,074.03 13,453,598.77
2341 AB RE-CDEF - LEASE C 456.4562.0330.3144.6506.030.0000 -123,456.78 -62,624.71 -542,017.98
2314 ABCDE & ABCD - ABCD 324.4561.1234.5678.0000.000.0000 -219,013.37 -27,366.04 -246,379.41
Ideally
All the text would be split.