topic Re: Split a string with a Carriage Return in the middle in Talend Studio

Split a string with a Carriage Return in the middle

vincecassel — Sat, 16 Nov 2024 02:35:10 GMT

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"

Re: Split a string with a Carriage Return in the middle

Anonymous — Mon, 27 Apr 2020 15:49:48 GMT

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

Re: Split a string with a Carriage Return in the middle

vincecassel — Fri, 08 May 2020 15:01:42 GMT

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