Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Splitting out Progress Array Fields - Crystal Reporting

Status
Not open for further replies.

shipcd

MIS
Mar 31, 2003
19
US
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
 
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>
 
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];
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top