Replace, Strip or Remove Text from a field 1

[product26]

Hello,

We have a field in our database which contains a formatted paragraph of text for each entry. I need to remove the formatting code from the field and list only the text. I have a list of all of the possible code to be removed, but I cannot get crystal to actually remove it.

I tried the replace function, but when I insert multiple replace functions it only processes the last one in the formula. for example, if the formula were:

REPLACE({orders.adtext},"[f4pc8fbya]","<B>");
REPLACE({orders.adtext},"[f4pc8ya]"," ");
REPLACE({orders.adtext},"[f4pc8s6.5]"," ");
REPLACE({orders.adtext},"[bs0,2,4]"," ")

it would only replace [bs0,2,4]with a space.

any suggestions?

 

[kray4660]

Yes, the formulas are working correctly. You have to remember that a formula in Crystal works a lot like a function. If you want all those actions to take place then you need to set up a variable and assign the replace statements to that variable (i.e.
stringvar resultstr;
resultstr := REPLACE({orders.adtext},"[f4pc8fbya]","<B>");
resultstr :=REPLACE(resultstr,"[f4pc8ya]"," ");
resultstr :=REPLACE(resultstr,"[f4pc8s6.5]"," ");
resultstr :=REPLACE(resultstr,"[bs0,2,4]"," ");
resutlstr;

I hope this helps.

 

[pmax9999]

Hi Product26

You could also avoid the use of variables by using nested REPLACE functions, as follows:

REPLACE(REPLACE(REPLACE(REPLACE({orders.adtext},"[f4pc8fbya]","<B>"), "[f4pc8ya]"," "), "[f4pc8s6.5]"," "), "[bs0,2,4]"," ")

Cheers,
Pete

 

[product26]

pmax9999 your suggestion worked perfectly!
THANKS!