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
September 10, 2023, 6:58pm
2
Hey @rodolphovieira
Try this :
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!!!
system
Closed
September 18, 2023, 8:14pm
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.