Remove the strings after a certain point


I have this set of data

The output I need is as below,


In the Column 2 there is abcdefghijk and then 13London and some random data. what it needs to do is to look for the first 13London and delete the rest of the data including 13London.

Hope this makes sense

Attached the input and the output
KNIME Question.xlsx (8.9 KB)

Appreciate any help

(bolded so that it can be seen clearly)

Hi @kanishka271

You can us a String Manipulation node,
substr($column1$,0 , indexOf($column1$,"13London" ))
It takes your input column1 and takes a substring from it, starting a the beginning (0) with the length of the position London13 starts.

gr. Hans


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