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

Crystal Reports

Last Comment

James0628

8/22/2022 - Mon

Kanti Prasad

7/16/2015

Hi

tst := Replace (tst,"CS" ,"PL" );

henry

7/16/2015

ASKER

My formula look like:
{Shipment.OrderReference}+space(1)+"-"+space(1)+{Shipment.ReleaseIdentification}

I need find and replace in Shipment.ReleaseIdentification

Where I should add your statement ?
thanks

h.

ASKER CERTIFIED SOLUTION

Kanti Prasad

7/16/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

James0628

7/17/2015

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.ReleaseIdentification},"CS", "PL")

James

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

Certified Expert Program

Credly Partnership

Udemy Partnership