TabDelimited - problem with quotes

D

Dolptrmn

There is a problem when I SaveAs excel file to TabDelimited text file.

If field text is:
Sample text "sample text",

in tab delimited file it is:
"Sample text ""sample text""".

If there are no quotation marks in field in XLS file, field is norma
in TXT file.

Is this a bug, and how can I prevent it
 
B

BrianB

Probably "a feature, not a bug" <<grin>>.

The global settings in Control Panel have some effect.

Normally such files are created to transfer data. Perhaps the targe
app. will correct it on import.

I would do a Replace " with ' (apostrophe/single quote) on the dat
before exporting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top