Crystal reports 8.5 - Split function oriented problem 1

[elangesk]

I m using Split fution in crystal reports 8.5, back end as Sql server. I explain my problem as follow:

In purchaseorder table with field name as special_instruction. with in the special_instrction there are & symbols are available.

for example onr record have special instruction has

1,2,4 Test certificate : applicable , chemical test : No
& 5,3 test certificate : no

another record's same special instrction has

1,2 Test certificate : applicable , chemical test : No
& 5,3 test certificate : no & 4 same all

for the above field i want split the string use & as delimter on the report time

How i will do , plz make it will slove.

 

[lbass]

You can use:

//{@firstelement}:
if ubound(split({table.string},"&") >= 1 then
split({table.string},"&")[1] else
{table.string}

//{@secondelement}:
if ubound(split({table.string},"&") >= 2 then
split({table.string},"&")[2]

//etc.

-LB