Hello everybody,
I have data as below in each row ,
0.00 0.54 0.04 23.1 7.9 0.0 0.0 24.0 7.3 3.4 0.0 -0.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.93 0.93 -3.2 -3.2 0.1 860.5 6.75 24.7 30.9 28.4
I need to extract each set of numbers into different columns . The numbers of spaces between the numbers vary depending on whether there are 1,2 or 3 digits before the decimals.
Cell splitter node and delimiter as space , is not working since the number of spaces vary.
I tried Regex Split node , but I am not able to find the correct pattern to split
hi @sriram5608
You can replace multiple spaces with a single one using this expression in a String Manipulation node strip(regexReplace($string$, " +", " ")) before using a Cell Splitter