I am new to Crystal and need to do the following:

 

I have a field that contains 3 values for each row.  For example:

 

1  Start  sysadmin

2  Write  wr1

3  End  sysadmin

4  Start  sysadmin

 

What I want to do is to pull out the second value to display on the report (i.e., Start, Write, End, Start).  One value per row.

 

I setup the following formula:

 

Local StringVar Owner;

Local StringVar Array OwnerArrayVar;

OwnerArrayVar := Split ({Project.Current_Routing}, " ");

Owner = (OwnerArrayVar [2]);

 

What I get back is "True" for some of the rows and blank for the rest.

Sarah,

 

Thanks for the feedback.  After playing around with it for a bit more, this is what I found worked.

 

 

Local StringVar Owner;

Local StringVar Array OwnerArrayVar;

OwnerArrayVar := Split ({Project.Current_Routing}, " ");

Owner := OwnerArrayVar [3];

 

I thought the blank would be a separator only but it was part of the array as well.  I thought I had 3 values as part of the array but I had 5 including the 2 blank spaces.

 

Problem solved!