dralagen/csv2xml

Problem with multi line fields in quotation marks

Closed this issue · 1 comments

entry1,entry2,entry3,entry4
value1,"text1

text2
","value2",value3

should produce

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document>
    <data>
        <element>
            <entry1>value1</entry1>
            <entry2>text1

text2
</entry2>
            <entry3>value 2</entry3>
            <entry4>value 3</entry4>
        </element>
    </data>
</document>

but produces

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<document>
    <data>
        <element>
            <entry1>value1</entry1>
            <entry2>text1

text2</entry2>
            <entry3/>
            <entry4/>
        </element>
        <element>
            <entry1>,"value</entry1>
            <entry2>value3</entry2>
            <entry3/>
            <entry4/>
        </element>
    </data>
</document>

instead. I've invested some time into an attempt to fix it, but before investing even more, I would rather do a rewrite, as I might need some adjustments anyway.

I success to fix parsing with

entry1,entry2,entry3,entry4
value1,"text1

text2","value2",value3

I have a problem when a line begin by end field limiter