Exporting table to .txt file adds quotes?

AtLarge

Registered User.
Local time
Today, 12:09
Joined
Oct 15, 2008
Messages
70
I did a search and do not find anything on this problems specifically. So, looking for some guidance. I wrote a macro to convert a table to a text file and leave it in a folder on my C drive. (one column, all part numbers so text only, no numbers or dates) The problem is that it's putting quotation marks before and after every part number and I can't have that or else I won't be able to upload it next.

I'm using Export Delimited as the transfer type in my macro. How do I stop this from occurring? TIA.
 
I did a search and do not find anything on this problems specifically. So, looking for some guidance. I wrote a macro to convert a table to a text file and leave it in a folder on my C drive. (one column, all part numbers so text only, no numbers or dates) The problem is that it's putting quotation marks before and after every part number and I can't have that or else I won't be able to upload it next.

I'm using Export Delimited as the transfer type in my macro. How do I stop this from occurring? TIA.

You need to set up an Export Specification which will allow you to select NONE for the text delimiters. If not sure how to do so, see here.
 
Thanx Bob. You da man!
 

Users who are viewing this thread

Back
Top Bottom