mult numbers in one field

[CPK6104]

Hello. I have a report that's using excel as its data source. Unfortuantely, it ocasionally has a field (a cell) that contains mult problem ticket numbers (instead of one prob ticket number in a cell, per record). In the cases where there are mult numbers, it looks like this: 12345, 42554, 88759, 46897 (#####, #####, #####, #####). When there are multiples, there could be 2 ticket numbers or more with no set limit.

Is there a way to pick out the individual prob ticket numbers so that each is associated with one record (one row in the spreadsheet)? Thanks in advance for your help.

 

[Madawc]

You could get the first element using

Split({your.field}, ", ")[1]

If there were always four, you could just repeat for 2, 3 and 4. If it's more complex, then use

Ubound({your.field}, ", ")

This would give you the number and you could use it for selective logic.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[CPK6104]

Thank you. I'll try it.