Removing Slashes & Dashes from a Phone/Fax Field

[aj3221]

I have a phone / fax field and need to pull out the "/" and "-" in the field.

The field currently displays:
518/555-0010

I need to display:
5155550010

Any help is appreciated!

Thanks

 

[MCuthill]

aj,

There are a couple of approaches, but the following should work nicely.

Left({YourField},3) & Mid({YourField},5,3) & Right({YourField},4)

You could also use the "Replace" function as well.

Hope this helps!


Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."