Escaping quotes in .csv mail merge data

G

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
 
P

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",
 
Top