Format phone number xxx-xxx-xxxx to (xxx) xxx-xxxx 1

[LisaRR]

I am trying to format a string phone number field from the current xxx-xxx-xxxx format to (xxx) xxx-xxxx.

I reviewed the posts in threat 767-608674 but I am not able to get the suggested formulas to work. This is what I have now:

stringvar fmtPhone;

replace(replace(replace(replace({TABLE.PHONE},"(", ""), ")", ""), "-", ""), " ", "");
"(" & left(fmtPhone, 3) & ") " & mid(fmtPhone, 4, 3) & "-" & mid(fmtPhone, 7, 4)

The result returns only the formatting, not the formatted field: Example:
() -

I also tried this:
StringVar fmtPhone;
fmtPhone = Replace( {TABLE.PHONE}, "(", "" );
fmtPhone = Replace( fmtPhone, ")", "" );
fmtPhone = Replace( fmtPhone, "-", "" );
fmtPhone = Replace( fmtPhone, " ", "" );

"(" & left(fmtPhone, 3) & ") " & mid(fmtPhone, 4, 3) & "-" & mid(fmtPhone, 7, 4) ;

with the same result.

anyone have any feedback for how to make these formulas work? Thanks!

 

[fisheromacse]

i think this might do it for you:
{@phone}
"(" & LEFT({table.phone},3) & ")" & RIGHT({table.phone),8)


my standard disclaimer plus a little extra applies today..... i do not have crystal in front of me so apologize for any errors or typos.
I am also a bit sleep deprived and there is not enough coffee in the building today to get me up to speed, so if i misunderstood your issue, additional apologies.

 

[fisheromacse]

if you may potentially have nulls in the data, add this line
IF is null({table.phone) then "" else

 

[LisaRR]

That did it - you understood perfectly. Thanks so much!!!!

 

[fisheromacse]

happy to be able to help.