Parsing CSV files with embeded double-quotes and commas

Original issue 404 created by 1kot... on 2014-05-14T12:08:16.000Z:

What steps will reproduce the problem?
1. Create a simpe CSV file (example attached)
2. Using tikal -x create a XLIFF file
3. The simple string within the quotes will be separated between several translation units

What is the expected output? What do you see instead?
CSV cell "Item 2, with \"quotes\"" should be exported as a single translation unit:

<trans-unit id="4" label="item1">
<source xml:lang="en">Item 2, with "quotes"</source>
<seg-source><mrk mid="0" mtype="seg">Item 2, with "quotes"</mrk></seg-source>
<target xml:lang="de"><mrk mid="0" mtype="seg">Item 2, with "quotes"</mrk></target>
</trans-unit>

But instead it generates a whole group:

<group id="4" restype="row">
<trans-unit id="4" label="item2">
<source xml:lang="en"><x id="1"/>Item 2</source>
<seg-source><mrk mid="0" mtype="seg"><x id="1"/>Item 2</mrk></seg-source>
<target xml:lang="de"><mrk mid="0" mtype="seg"><x id="1"/>Item 2</mrk></target>
</trans-unit>
<trans-unit id="5" label="item2">
<source xml:lang="en">with \<x id="1"/>quotes\<x id="2"/><x id="3"/></source>
<seg-source><mrk mid="0" mtype="seg">with \<x id="1"/>quotes\<x id="2"/><x id="3"/></mrk></seg-source>
<target xml:lang="de"><mrk mid="0" mtype="seg">with \<x id="1"/>quotes\<x id="2"/><x id="3"/></mrk></target>
</trans-unit>
</group>

What version of the product are you using? On what operating system?
This happens for the latest version (24) both on Mac OSX 10.9 and on linux (Linux version 3.5.0-48-generic (buildd@ batsu) (gcc version 4.6.3 (Ubuntu/Linaro 4.6.3-1ubuntu5) ))

Comments (2)