How to remove commas from a number 1

[fa721]

Hello,
Phone numbers on my report (Crystal Reports 8.5) come out as:
xxx,xxx,xxxx (number field)

I want to change the format so they would be displayed as:
(xxx) xxx-xxxx

I am using the Picture and ToText functions to create a new field with the right format in the field Editor. However, what I have not been able to figure out is how to first remove the commas from the number. Can anybody help? Am I on the right track Picture and ToText functions? What is the best way to resolve this problem?

Your help will be greatly appreciated.

Fa721

 

[putts]

replace(toText({numberField},",","&quot

 

[resdevlabs]

Try this:

Picture( Replace( {phone_field}, ",", "" ), "(xxx) xxx-xxxx&quot

 

[fa721]

Thanks this is great!

I just realized that the original format is:
XXX,XXX,XXXX.00
How do I use the 'replace' function to get rid of commas as well as the decimal point and trailing zeros in one formula.

i would appreciate it if you would be kind enough to write the whole formula from start to end for me. I've trying and I keep getting errors.

Thanks again.

Fa721

 

[dgillz]

picture(totext({YourNumberField},0,"&quot,"(xxx) xxx-xxxx&quot

works for me on a number field.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com