Hi,

I want to save a spreadsheet that contains text strings with double quote in
csv or txt format, but when I save and open in textpad or notepad, its adds
extra double quotes.

e.g.
cell A1 - "TEST"
textpad - ""TEST""

Also if you have double quotes inside a string its also adds them to start
and end of the string...

cell A1 - This i "a" Test
textpad - "This is ""a"" Test"

I am creating various files that are read by a bespoke application and
requires double quotes in certain parts of a string to interpret the code.

My current code just takes the strings simliar to below and saves as a text
file.

SYMBOL="SYMBOL123"
DESCRIPTION="Historic Data
EXCHANGE=UBSC
INSTRUMENT-TYPE=3
VOLATILITY=0
TRADING-UNITS=100

Is there anyway around this duplication of double quotes?

Thanks,

B/