Four Stars

separate a chain in more than 2

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

CategoryProyType
Técnica, Técnica, Técnica, Técnica, Técnica173Externa; Externa; Externa; Interna; Interna
Administrativa; Administrativa; Administrativa; Administrativa186Externa; Externa; Interna; Interna
Financiera; Financiera158Externa; Externa



To appear as follows..

 

Caterory_1Caterory_2Caterory_3Caterory_4Caterory_5ProyTipo 1Tipo 2Type_3Type_4Type_5
TécnicaTécnicaTécnicaTécnica 173ExternaExternaExternaInternaInterna
AdministrativaAdministrativaAdministrativaAdministrativaAdministrativa186ExternaExternaExternaExterna 
FinancieraFinanciera   158ExternaExterna   
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: separate a chain in more than 2

3 REPLIES
Six Stars

Re: separate a chain in more than 2

Four Stars

Re: separate a chain in more than 2

thank you very much!!

Six Stars

Re: separate a chain in more than 2

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