Phone # Formula or Function 2

[Bentk]

I am trying to format a phone number that is a string to look like this.

Currently the info returned from SQL is 1234567890
I need to make it format to 123-456-7890
Does anyone know of a function or formula that could make this happen?

Thanks in advance,
Bentk

 

[dgillz]

Write a formula:

Picture({yourField},"xxx-xxx-xxxx")

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

http://www.gainfocus.biz

 

[synapsevampire]

Try a formula containing:

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

You also might want to sanity check, as in:

If len(trim({table.field})) = 10 then
picture(totext({table.field}), "XXX-XXX-XXXX")
else
"!!!" &{table.field}&"!!!"

-k

 

[Bentk]

k
Thanks so much, I was not aware of the picture function. That's a lifesaver. Worked like a champ.

Thanks,

Bentk