G
Guest
Guest
I'm using Excel to create a tab delimited flat file that will be imported into another system.
I have a macro written to save the file as a tab delimited text file. For the most part everything works file. However, there are some cases where Excel is including unneeded quotes in the text file.
Example - Cell A1 has the following contents: FCPLT,FM-WLI-16E1B
Save as Text File (tab delimited).
Open the text file and it now reads: "FCPLT,FM-WLI-16E1B"
In this case the quote is added because of the comma. If I change the comma to a dash it works perfectly. However, I don't have a choice, I need to maintain the original format. In cases where a quote exists in the original entry, Excel adds an additional quote (" -> "").
Is there are way to prevent this?
Thanks,
Brent
I have a macro written to save the file as a tab delimited text file. For the most part everything works file. However, there are some cases where Excel is including unneeded quotes in the text file.
Example - Cell A1 has the following contents: FCPLT,FM-WLI-16E1B
Save as Text File (tab delimited).
Open the text file and it now reads: "FCPLT,FM-WLI-16E1B"
In this case the quote is added because of the comma. If I change the comma to a dash it works perfectly. However, I don't have a choice, I need to maintain the original format. In cases where a quote exists in the original entry, Excel adds an additional quote (" -> "").
Is there are way to prevent this?
Thanks,
Brent