Corel X3 Print Merge Commas

[Bill Jermyn]

I've been googling for a while and can't seem to find out if it's possible to escape a comma in a merge file, that is to print a comma in a field, rather than having it delimit the fields. Anybody figured out if it's possible?

[Gary Hair]

I think if you wrap it around quotes it will work ",". If not, save as a quote delimited file and it will merge everything but quotes.

Gary

[Bill Jermyn]

The second suggestion worked, i.e.;
"field1","field2,print this comma"

Thanks Gary!

[Roy Brewer]

I've been googling for a while and can't seem to find out if it's possible to escape a comma in a merge file, that is to print a comma in a field, rather than having it delimit the fields. Anybody figured out if it's possible?Bill,

A couple thoughts that might help, especially if you use Excel. First, if you save as TAB delimited then Excel will automatically place the extra brackets around the fields including a comma.

But why would you do that? Forget saving it as anything other than an XLS and use Corel's terrific ODBC facility to bring it straight from the .XLS (commas are handled as you want).
http://www.youtube.com/watch?v=bRCYZT7cRR8 (http://www.youtube.com/watch?v=bRCYZT7cRR8) if you are not into ODBC.

[Mike Null]

Excellent, Roy.

Just for our members info, Roy has a number of other Corel tutorials on his web site at http://www.engravingconcepts.com/.

Just go to the training tab and follow the tabs from there.

[Bill Jermyn]

Bill,

use Corel's terrific ODBC facility
Thanks, Roy. The problem was that it wasn't in Excel, just text copied from a customer's email.

Anyway, problem solved, thanks everybody.

As usual, it took just a few minutes to get the answer from this great forum!