topic Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows in Talend Studio

Split the input string based on \n (newline character) and then assign each string to different n number of rows

sk0 — Fri, 15 Nov 2024 22:56:38 GMT

Hi,

requirement: Split the input string of one column based on \n (new line character) and then capture first 5strings that are splitting earlier and then assign those 5strings to 5 different rows

How can do this

Actually I am reading a column which has n-number of strings with the new line character as a separator.

I need to read the whole string and then split the string based on newline character and then assign the 1st string to one output component and 2nd string to another output component and 3rd string to third output component.

Can do this in tmap? If yes can someone please share me the example. Or if there’s another approach please let me know with an example.

input column1:

data

mailing

details

output:

row1: Data

row2: mailing

row3: details

thanks in advance!

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

Anonymous — Mon, 09 May 2022 04:38:45 GMT

Try the tNormalize component, this component can be used to split the column value to multiple rows.

Regards

Shong

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

sk0 — Tue, 24 May 2022 03:16:08 GMT

Hi @Shicong Hong I tried using tNormalize component and it didnt worked for me. In ITEM SEPARATOR i mentioned as "\n"

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

sk0 — Tue, 24 May 2022 03:30:06 GMT

Can someone please help with the above issue

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

Anonymous — Tue, 24 May 2022 03:59:34 GMT

@S K, Which OS? I made a testing on Windows, read the file content as a string , the file has 3 row of data in it , I set the separator as "\r\n" on tNormalize component, see below.

Regards

Shong

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

sk0 — Tue, 24 May 2022 04:57:56 GMT

I used tfileinputdelimited and it didn’t worked but when I used tfilerawinput component it worked fine. Is there’s a way that I can implement the same logic in tmap? Please let me know

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

Anonymous — Tue, 24 May 2022 05:15:26 GMT

where's the data are stored in real case? tfileInputRaw read the whole file content as only one row, tfileInputDelimited read the file line by line and the output data will not contain \n new line character.

tMap is not the right component used to split one row to multiple rows.

Re: Split the input string based on \n (newline character) and then assign each string to different n number of rows

sk0 — Tue, 24 May 2022 05:18:57 GMT

Thanks Shong for your time and help. Appreciated