String to (814) 555-1212 1

[prl423]

How do I convert the string to a phone format. Example is ..... 8145551212 to (814) 555-1212 Thanks in Advance...Using crystal 8.5 SQL DB

 

[MCuthill]

prl423,

I did this in CR10, hope these functions are available in 8.5.

whileprintingrecords;
StringVar FormattedPhone;
StringVar AreaCode;
StringVar PrefixThree;
StringVar SuffixFour;

AreaCode:= Left({?Phone},3);
PrefixThree:= Mid({?Phone},4,3);
SuffixFour:= Right({?Phone},4);

FormattedPhone:= "(" & AreaCode & ") " & PrefixThree & "-" & SuffixFour;

Hope This Helps,


Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[synapsevampire]

Try:

picture({table.stringfield},"(XXX) XXX-XXXX")

This assumes it's a string, if it'sa numeric use:

picture(totext({table.stringfield},0,""),"(XXX) XXX-XXXX")

-k

 

[prl423]

Thanks to those how helped.....much appreciated.