Splitting out Progress Array Fields - Crystal Reporting

[shipcd]

I have several progress fields which store arrays of data. When trying to report on that data in Crystal, it reads through as one field.

What is the best way to read the multiple arrays as separate fields? The multiple arrays may or may not be populated, so a mid-character function breakout doesn't work.

Thanks for any information you can share. Examples attached:

Field Name: LCODE[1-5]
Potential Entries in Field:
ID, ID, ID, ID
ID,,ID,ID
,,,ID
ID,,ID

 

[harebrain]

If I remember correctly, the field you get in Crystal is a semi-colon delimited string. It should be trivial to separate the individual cells.

<rant>
Whoever had the idea to include this feature in Progress should be confined in an institution where he can do no more harm.
</rant>

 

[teknogeek9]

Crystal has a function called split. Something like below should work for you.

stringvar Lcode1 := split(LCODE[1-5],',')[1];
stringvar Lcode2 := split(LCODE[1-5],',')[2];
stringvar Lcode3 := split(LCODE[1-5],',')[3];
stringvar Lcode4 := split(LCODE[1-5],',')[4];
stringvar Lcode5 := split(LCODE[1-5],',')[5];