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.
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.
