Split a String to be shown on Cross tab headers

building reports crystal reports
1

Hi,

I have a String that has values as follows :
“CountryName1-CntryCode1 ,CountryName2-CntryCode2, CountryName3-CntryCode3” and so on.
This value will be entered by user in a prompt so we really do not know how many individula Cntryname-code they might enter.

I have to split the strings after every comma which means CountryName-CntryCode and display this as a Cross tab Column header.

When I use Split function and an array to capture these values I get either an error - “This array must be subscripted. For example: Array [i].”
or I see the last value of the String.

Any help would be greatly appreciated.

Regards
Sija

sijasethu :india: (BOB member since 2009-01-07)