Exporting phone numbers and zip codes???

[jmlbones]

I have a table that stores phone numbers and zip codes as text format. A phone number looks like this 1112223333 and a zip looks like this 111112222. I am trying to export to a fixed length text file that requires phone numbers like this 111/222-3333 and zips like this 11111-2222. Is there an expression I can use in the query that I am using to export the data to allow the text file to be populated appropriately? Or, any other suggestion?

 

[JoeMiller]

The format function will allow you to do this.

Phone number field:
[tt]
FormattedPhone: Format([MyPhoneField],"(###) ###-####&quot
[/tt]

For the zip code it can be a little trickier, you have to test for a 9 digit or 5 digit zip, then apply the formatting.
[tt]
FormattedZip: IIf(Len([MyZipField])=5,Format([MyZipField],"00000&quot,Format([MyZipField],"00000-0000&quot)
[/tt]

HTH Joe Miller
joe.miller@flotech.net