How to calculate the occurrence of names in rows and string inside rows

[Anonymous]

Hi Experts,

I am come across a situation where i need to calculate the no of occurrence of individual names presents in rows of field and string inside a field.

string inside rows are saparated by ";" (semicolon).

Please help me out to resolve this issue.

Is there any way to get all the semicolon separated values in new row??

Thanks in advance. Please find the attached data file and sample qvw.

Regards,

aashish.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[Anonymous]

Thanks Gysbert!!