LOOP THROUGH ALL OCCURANCES IN FIELD

[SusanStoHelit]

We are using crystal XI on an Oracle database. We have a certain 14-digit number that can show up anywhere from 0-20 times in a field, always after the words "Order Number: ".

I need a way to loop through all occurences of "Order Number: " to pull those numbers out.

Thanks!

 

[lbass]

stringvar array x := split({table.string}, "Order Number: ");
numbervar i;
numbervar j := ubound(x);
stringvar y;

for i := 2 to j do(
y := y + left(x,14)+ ", "
);
y

-LB

 

[SusanStoHelit]

That worked!

thank you