My first post and I am hoping someone can resolve this strange dilemma.
I am creating a text file by exporting the results of a query. One of the fields is a phone number that is formatted 999.999.9999
Unfortunately not all exported phone numbers are correctly formatted in the resulting file. Some lose the periods and look like this: 9999999999. Others however are formatted correctly.
All of the phone numbers are formatted correctly in the query prior to being exported.
Thanks in advance for any assistance with the dilemma.