I need help. I have string values in a certain column. From these values I need to extract an excerpt. I need to extract the text between the 1st and 2nd “.” . Here’s the example:
301092.CORR.COR.02 => CORR
301092.CORR.COR => CORR
301092.CORR => CORR
Try this :
split cells.knwf (1.2 KB)
Has the text the same length? → String Manipulation node (substr method + index of)
Other option would be regex and try sth like \d+\.(.*?)\.
Thank you very much! It worked!
I managed it according to the previous suggestion, thank you very much too!!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.