TabDelimited - problem with quotes

  • Thread starter Thread starter Dolptrmn
  • Start date Start date
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
 
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
 
Back
Top