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)