topic Re: Spli a line into multiple rows accoring the special character in Talend Studio

Spli a line into multiple rows accoring the special character

DrGenious — Fri, 16 Oct 2020 13:47:40 GMT

Hi,

I have a line like this :

1,ted,ball,house~office~ship~school.

I want to split the above line into this:

1,ted,ball,house

1,ted,ball,office

1,ted,ball,ship

1,ted,ball,school

Can you help ?

Anonymous — Wed, 04 Nov 2020 09:11:51 GMT

Hello,

Please have a look at this component TalendHelpCenter: tExtractDelimitedFields which generates multiple columns from a delimited string column.

You can use it to split your line with "~" filed separator and join other columns via tMap component.

Best regards

Sabrina