Split data if it does not contain text

[soninya]

My data set includes numbers and text in the same column. I´d like KNIME to split data if the cell contains number but not if it contains text. Is there a possibility to do so?

[gonhaddock]

Hello @soninya and welcome to the KNIME community

This challenge description sounds like a regex job to me. We could help you to find a convenient solution, if you can provide a representative sample data of column’s target formats. Adding an example of expected output too, would be a plus.

BR

[soninya]

Hello @gonhaddock and thanks for the welcoming words

See a table with input and expected output attached.

~soninya

Book1.xlsx (8.8 KB)

[gonhaddock]

Hello @soninya
Thank you for the example data. You can try with ‘Regex Split’ node:

(\d+|.*$)\s?(.*)

BR

[soninya]

Hello @gonhaddock. This works well, thank you!!

I have another data set where numbers are separated by “.” looking like this: “10.100.110 Text”
With the Regex above the number is split like this: “10.” " 100.110 Text"
Can you help me to adjust the Regex so that it would be split like this: “10.100.110” “Text”

Thank you!

~soninya

[gonhaddock]

Hello @soninya
This code is working in my side:

([.\d+]+|.*$)\s?(.*)

BR

[soninya]

Thanks for your help!