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.
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.