How to Split one column based on there spaces.

How to Split one column based on there spaces.

Sample below
Numbers Only
3,602.40- 3,602.40- 0.00 0.00 3,602.40 3,602.40
3,602.40 3,602.40 0.00 0.00 3,602.40- 3,602.40-
76.26 102.94 0.00 0.00 76.26- 102.94-
76.26- 102.94- 0.00 0.00 76.26 102.94
2.08- 2.04- 2.08- 2.04- 0.00 0.00
121.45- 21.02- 121.45- 21.02- 0.00 0.00
155.88- 26.98- 155.88- 26.98- 0.00 0.00
1.42- 0.24- 1.42- 0.24- 0.00 0.00
1,114.98- 193.04- 1,114.98- 193.04- 0.00 0.00
564.69- 97.77- 564.69- 97.77- 0.00 0.00
1259,613.96- 218,090.41- 1259,613.96- 218,090.41- 0.00 0.00
774.70- 774.70- 774.70- 774.70- 0.00 0.00
7.12- 7.12- 7.12- 7.12- 0.00 0.00
10.48- 10.48- 10.48- 10.48- 0.00 0.00
0.03- 0.03- 0.03- 0.03- 0.00 0.00
0.10- 0.10- 0.10- 0.10- 0.00 0.00
12.43- 18.36- 12.43- 18.36- 0.00 0.00
0.03- 0.04- 0.03- 0.04- 0.00 0.00
image

Hi @seanmanzanilla , you can use the Cell Splitter node, configured with a space as delimiter:

Input:
image

Results:
image

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.