Crystal - Return values in string seperated by & sign into seperate fields

You can split the field into an array of strings with the SPLIT function

Split({YourField},'&')

You can then display them individually with Split({YourField},'&')[1]

To preserve the values for use in other formulas create a formula

WhilePrintingRecords;
Global StringVar Array arrDates;
arrDates := Split({YourField},'&');
''

Select allOpen in new window

In another formula you can display the values

WhilePrintingRecords;
Global StringVar Array arrDates;
arrDates[1]

Select allOpen in new window

mlmcc

If the number of values in the field can vary, you can use UBound to test how many values there are, to avoid getting a subscript error.  For example, if the field contained "06/01-120&06/01-228", that would give you an array with 2 elements, so Split ({field}, "&") [ 3 ] would give you an error.  You can avoid that by using something like this:

if UBound (Split ({field}, "&")) >= 3 then
  Split ({field}, "&") [ 3 ]


 James

There could be only one value in the field or 3 or 4.  I tried adding the UBound to the first part of the formula but returned 0 results. When i use the original formula provided it just give me error "A subscript must be between 1 and the size of the array"

This worked perfect!

Thank you.