topic Re: separate a chain in more than 2 in Talend Studio

separate a chain in more than 2

Anonymous — Mon, 06 Nov 2017 18:09:47 GMT

How can I separate the value of a string by more than 2, delimiting it by ";"

Category	Proy	Type
Técnica, Técnica, Técnica, Técnica, Técnica	173	Externa; Externa; Externa; Interna; Interna
Administrativa; Administrativa; Administrativa; Administrativa	186	Externa; Externa; Interna; Interna
Financiera; Financiera	158	Externa; Externa

To appear as follows..

Anonymous — Tue, 07 Nov 2017 08:26:20 GMT

Anonymous — Tue, 07 Nov 2017 22:12:15 GMT

thank you very much!!

Anonymous — Wed, 08 Nov 2017 02:15:38 GMT

Please give kudos (like button) to answers, if it helped.