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?
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
Hello @gonhaddock and thanks for the welcoming words
See a table with input and expected output attached.
~soninya
Book1.xlsx (8.8 KB)
Hello @soninya
Thank you for the example data. You can try with ‘Regex Split’ node:
(\d+|.*$)\s?(.*)
BR
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
Thanks for your help!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.