Escaping quotes in .csv mail merge data

[GDR]

When doing mail merge from a .csv data file, the mail
merge blows up when there are double quotes (") in any of
the data fields. Is there any way to escape these extra
quotes?

TIA,

GDR

 

[Peter Jamieson]

Can't remember off the top of my head what works with .csv, but I am
reasonably sure that the only think that /might/ work is to double up each
double quote in the data, i.e. replace

,"abc","d"ef","ghi"

by

,"abc","d""ef","ghi"

Even if that works, you may find that things are slightly different in the
case where the quote is at the beginning of the field, e.g. I'm not sure
changing

,""jkl",

to

,"""jkl",

works. If not, you could try

," ""jkl",