multiline strings

Submitted by suydam on Mon, 2008-01-14 11:34 in Magic Parser

I export data from Microsoft Excel for use with MagicParser.
The only problem I'm having now (thanks for helping me with my last one!) is this:

Excel insists on preserving carriage-returns in strings. So, if I have the following records, I've got a big problem.

"SKU";"Title";"Description"
"A-123";"Product A";"Product A is a fantastic addition to your home"
"A-456";"Product b";"Product b is a fantastic
addition to your home"
"A-789";"Product c";"Product c is a fantastic addition to your home"

I get 4 records from Magic Parser in that example....2 of which (A-456 and row 3) are completely jacked.

Any advice?

Thanks again. Your product works great, it's Excel that's annoying me. :)
Brian

Hello Brian, Multi-line

Submitted by support on Mon, 2008-01-14 12:00

Hello Brian,

Multi-line strings are supported by Magic Parser, but a recent change (to support even more complication record delimitation) had introduced an error into this section of the code.

I have now fixed this, so if you download Magic Parser again the above CSV containing new-line characters will be handled correctly, provided that there is a text-delimiter specified. I used the following format string in testing the above CSV:

csv|59|1|34

Cheers,
David.