parsing string based on multiple delimiters

Hello all,
I need some help with parsing a string based on several delimiters, and place them in to arrays.

Here is an example string that needs to be parsed
"A:Test,Test2; B:Sample, Sample2;C:Toparse1, Toparse2"
This string must be parsed via ( : , ; )and put into two Arrays labeled Impact, System
The resulting set should look like

Impact System
A Test
A Test2
B Sample
B Sample2
C Toparse1
C Toparse2

Clarification: each Impact is separated by ; and within each impact system is separated by ,
The System name has a : as you can see from the string.


Any help would be greatly appreciated... Thanks!!

Michael Chang

Try this. Assumes data in A and puts results in K&L:

Please Login or Register  to view this content.

Please Login or Register  to view this content.