Hey @masyukun , great library here. Ran into one issue though:
let $text := 'Test1,Test2
"1a,1a2",1b,
2a,"2b,2b2"
'
return csv:parseFile($text, true())
Returns:
"1a1a2"1b
2a"2b,2b2"
It appears that when the first value in a row has double quotes around it, the double quotes are not processed correctly, and you get two fields instead of just one.
Hey @masyukun , great library here. Ran into one issue though:
let $text := 'Test1,Test2
"1a,1a2",1b,
2a,"2b,2b2"
'
return csv:parseFile($text, true())
Returns:
"1a1a2"1b
2a"2b,2b2"
It appears that when the first value in a row has double quotes around it, the double quotes are not processed correctly, and you get two fields instead of just one.