Parsing quoted CSV with header row (csv|59|1|3)

Submitted by nutkenz on Wed, 2008-07-09 11:54 in Magic Parser

I'm trying to parse a CSV feed using the csv|59|1|3 formatter, but the quotes are still appearing in the parsed results:

price "30.39"
shipping "2.00"

Hi, The quote character

Submitted by support on Wed, 2008-07-09 11:57

Hi,

The quote character should be "34" for quoted text, unless it is a typo in the post please try:

csv|59|1|34

Cheers,
David.

Thanks for the quick

Submitted by nutkenz on Wed, 2008-07-09 12:06

Thanks for the quick response. The problem was that the last character was being chopped because I set the limit for the formatter to 10 characters. I didn't notice this until you pointed it out to me.