Hi - I'm new to crystal reports.  I want to create a formula that will split a text string into 4

The text string field has this format:

date - supplier - mfg - description

example: 04/12/2012 - Costco - Cisco - maintenance support

I want to split the text where it is divided by " - "

so the end result would be a formula for each of the 4 items below.

Formula 1's results: 04/12/2012
Formula 2's results: Costco
Formula 3's results: Cisco
Formula 4's results: maintenance support

how do I do this?

Thank you SonoItaliano,

When I do that, is displays this error:

"The result of the formula cannot be an array"

Figured it out....used this formula create the array.  The "" is so that the formula doesn't result in an array.

Formula 1:
whileprintingrecords;
stringvar array values:=Split({field}, "/");
""

Formula 2 (3,4, etc ) used to display each position within the array:
whileprintingrecords;
stringvar array values;
values[1]  //increment for each member