Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal reports 8.5 - Split function oriented problem 1

Status
Not open for further replies.

elangesk

Technical User
Jun 10, 2005
7
IN
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.





 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top