How to do nested "replace" statements 2

[zencalc]

I have a phone number field in a report that is a jumble of numbers and/or spaces/ and or dashes, ("-" or " &quot. My formula to get rid of these characters was

if "-" in {EnrCommunicationInfo.CommValue} then Replace ({EnrCommunicationInfo.CommValue},"-" ,"&quot else
if " " in {EnrCommunicationInfo.CommValue} then Replace ({EnrCommunicationInfo.CommValue}," " ,"&quot else
{EnrCommunicationInfo.CommValue}

but I noticed that it only does one or the other of the operations. But I have a couple of records that have format XXX XXX-XXXX, so it only gets rid of one of them. How do I nest these statements so that it will take care of both of them? thanks in advance.
Brian

 

[BobSuruncle]

What version of CR are you using?


HTH
Bob Suruncle

 

[zencalc]

8.5

 

[synapsevampire]

Try:

Replace(Replace({EnrCommunicationInfo.CommValue}," " ,"&quot,"-","&quot

You don't need any IFs.

-k

 

[zencalc]

OH YEAH!!!
Thanks, bro... works like a charm.
(Rack him.)
Brian

 

[BobSuruncle]

Local StringVar new_phone;
new_phone := Replace ({Customer.Phone},"-" ,"" );
new_phone := Replace (new_phone," " ,"" );

HTH



Bob Suruncle