Extract text between delimiters

Hey guys!

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

1

Hey @rodolphovieira

Try this :

image

split cells.knwf (1.2 KB)

Best,
Adam

3 Likes

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!

1 Like

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.