Extract text between delimiters

[rodolphovieira]

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

[Add94]

Hey @rodolphovieira

Try this :

split cells.knwf (1.2 KB)

Best,
Adam

[Daniel_Weikert]

Has the text the same length? → String Manipulation node (substr method + index of)
Other option would be regex and try sth like \d+\.(.*?)\.

[rodolphovieira]

Thank you very much! It worked!

[rodolphovieira]

I managed it according to the previous suggestion, thank you very much too!!!