separate a chain in more than 2

[Anonymous]

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..

Caterory_1	Caterory_2	Caterory_3	Caterory_4	Caterory_5	Proy	Tipo 1	Tipo 2	Type_3	Type_4	Type_5
Técnica	Técnica	Técnica	Técnica		173	Externa	Externa	Externa	Interna	Interna
Administrativa	Administrativa	Administrativa	Administrativa	Administrativa	186	Externa	Externa	Externa	Externa
Financiera	Financiera				158	Externa	Externa

[Anonymous · Accepted solution]

You can use TExtractDelimetedFields.


https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/0is4W2Xc7rQp8mFGjxIDRw

[Anonymous]

thank you very much!!

[Anonymous]

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