you can try string manipulation node with regexReplace and replace “[^\\d+]” with “” to get the numbers. If you like to keep the original column you can use string manipulation node to create a copy of your column first
See this wf some_filtering.knwf (35.6 KB)
It uses the regexreplace function suggested by @Daniel_Weikert that helps to identify the numbers. With that info available you some additional KNIME nodes to find a way to a possible solution.
Question1: First of all, can you change the export this information position or put some delimiter to separate the kind of information? If yes, It can be easier for you when you import using csv reader node.
Question 2: You can use regex to find the item and put it to the end of this string, using something likle it:
= regex replace(string,“(.)( \d+\w)( .)”,“$1$3$2”
This will get all the first part the string and set as the first part to result, then get the number and letters between then to put at the end of the string.
\d+ => digitis from 0 to 9 repeatly
\w => a word (letters, hifen, underline, point)
Well another approach to filter the relevant numbers only, is to use the KNIME TextProcessing extension.
The BagOfWords node, expand every line into separate words, which gives mores opportunities to filter and modify, See: KNIME_project_2.knwf (68.9 KB)