henry
asked on
find and repalce string in field
Hello,
Looking for crystal formula let me find specific text in string field and replace with other text.
I'm looking for CS, should be replace by PL
thanks
henry
Looking for crystal formula let me find specific text in string field and replace with other text.
I'm looking for CS, should be replace by PL
thanks
henry
ASKER
My formula look like:
{Shipment.OrderReference}+ space(1)+" -"+space(1 )+{Shipmen t.ReleaseI dentificat ion}
I need find and replace in Shipment.ReleaseIdentifica tion
Where I should add your statement ?
thanks
h.
{Shipment.OrderReference}+
I need find and replace in Shipment.ReleaseIdentifica
Where I should add your statement ?
thanks
h.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not expecting any points for this. Use Replace, as Kanti Prasad suggested. In this case, you can just replace the field with the Replace function.
{Shipment.OrderReference}+ space(1)+" -"+space(1 )+
Replace ({Shipment.ReleaseIdentifi cation},"C S", "PL")
James
{Shipment.OrderReference}+
Replace ({Shipment.ReleaseIdentifi
James
tst := Replace (tst,"CS" ,"PL" );