parsing multiple names in string separated by semi-colon

[sgdcatz]

There is a field in my data whose value may have several names separated by a semi-colon, for example "Smith, John; Doe, Jane; Smith, Mike".
I would like to parse these names out to show as separate field values. I know an InStr formula would be involved, but I do not know where to start.

 

[dgillz]

If you have George Pecks book look on pg 135.

Split({stingfield},";&quot seems to be the key but I cannot get it to work. You have to declare an array variable to make this work, but I just spent 30 minutes with no success. Any ideas? Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[sgdcatz]

I found an article c2000494 on the Crystal Decisions website. Would this be appropriate for what I am trying to do?

 

[dgillz]

Sdgcatz-

post the link and I'll check it out. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office