How to extract number and letter in 1 column

KNIME Analytics Platform
#1

Continuing the discussion from How to extract number and letter in 1 column:

Or How to split number into columns that contains white spaces
I tried using regex split
Code for split number=([0-9]) ([0-9]) ([0-9]) ([0-9]) ([0-9]) (.)

        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
#2

Hi @seanmanzanilla -

Were you able to find a solution for this one yet? I saw you had posted a few other topics, one of which ultimately involved the Cell Splitter node on spaces, as opposed to RegEx.

1 Like
#3

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