string manipulation knime

Good evening guys, how are you ?

Is there any node that can identify a word that follows in a column, and change it to the correct one.

Example: 3/4 would need to be MEDIUM - 3/4

Hello @Gabriel2020

Please try such a short workflow


Also attached.
String_manipulation.knwf (12.0 KB)

I hope this might help you.
Have a good day,
Kaz

1 Like

Hi @Kazimierz,
Good solution! An alternative might be to not split the table at all, but just use the String Manipulation node with the replace() function: replace every occurrence of “3/4” by “MEDIUM - 3/4” and you get the same result, but with 1 node instead of 4.
Kind regards,
Alexander

3 Likes

Hi @Gabriel2020

Or use the RuleEngine node :grinning:.

image
gr. Hans

4 Likes

Hi @AlexanderFillbrunn
On one hand you are right - it could be simplified.
On the other - we don’t know what are possible combinations of ‘3/4’ and other characters. Thus, @Gabriel2020 might need to adapt any proposed solution to his expectations.
Happy KNIMEing,
Kaz

1 Like

Thanks a lot guys, both solutions suit me. I had previously used string manipulation, but I thought there was another node with this function.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.