Spli a line into multiple rows accoring the special character

[DrGenious]

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]

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