Dividing a string 1

[iwm]

I am trying to divide the following string:

"Departure|Arrival|Time|Expenses"

This string will be used to populate the details section of a report. I need to divide the string at the pipe symbols(|) producing the following four individual fields:

Departure Arrival Time Expenses

Do you know of any way to divide this string into the desired individual fields. Is there a string function in Crystal Reports 9 that can be used to accomplish this task?

Your assistance in this matter is greatly appreciated.

 

[dgillz]

Split({YourField,"|"} will createan array. You can then get the individual components as follows:

Split({YourField,"|"}[1]
Split({YourField,"|"}[2]
etc., etc.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[iwm]

Thank you very much! Your solution was perfect!