Split a string with a Carriage Return in the middle

[vincecassel]

Hello to everybody,

I have a problem and I don't know if I can resolve it.

I have a field (from an Hive 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 is like "London".

Does anybody know how can I do?

The row separator is "\n" and the field separator is "\t"

[Anonymous]

You need use row1.Addresscomplete.replaceAll("\\n", "|"). You can then use "|" character to split the string 

[vincecassel · Accepted solution]

I resolved using this function:
(AddressComplete.split("\r\n").length > 1 ?
(AddressComplete.split("\r\n")[1]):Address)