Exporting phone number input masks to text

  • Thread starter Thread starter WSM
  • Start date Start date
W

WSM

Table has fields for both phone numbers and fax numbers.
They both use the Phone Number input mask.

When exporting to text, it is exported as a string of ten digits.
nnnnnnnnnn

Is there an expression to create a caluculated field, or some other
method, to get it to look like a phone number in the text file
(nnn) nnn-nnnn

Thank You
Bill
 
Hi Bill,

Use the Format() function in a calculated field. The format string will
be something like "(000) 000-0000".
 
Back
Top