I have a problem and I don't know if I can resolve it.
I have a field (from a table) that have a Carriage Return in his middle (it is a field called AddressComplete and it has the street and the city), I want to take the street when the city contains "London".
Does anybody know how can I split this field? The row separator is "\n" and the field separator is "\t" (I'm using Talend, with Java language)