Re: tabular is not handling "" escapes

[Ivan Raikov]

Hi Matt,

Thanks, I think the default line terminator is the newline character,
which would not work on files with DOS-style line endings. Could you
call the reader with option eol: "\r\n" to see if this fixes the
problem?

-Ivan

On Fri, Mar 6, 2020 at 11:24 AM Matt Welland <address@hidden> wrote:
>
> Thanks Ivan, I much appreciate the support.
>
> I tested 1.2 and it does solve the escaped quotes problem. I do now see 
> another problem. Multi-line cells cause the parser some grief. The attached 
> test.csv generated from Excel imports fine to gnumeric but fails with an 
> "unable to parse record" with tabular.
>
> On Fri, Mar 6, 2020 at 8:16 AM Ivan Raikov <address@hidden> wrote:
>>
>> Hi Matt,
>>
>> Thank you for using tabular and for reporting this issue. This was
>> indeed a bug in the code that handles escaped quotes. I have fixed it
>> and have made a new release (1.2). Let me know if you run into any
>> other issues. Best regards,
>>
>> -Ivan
>>
>> On Thu, Mar 5, 2020 at 2:14 PM Matt Welland <address@hidden> wrote:
>> >
>> > It is common in csv to escape double quotes with double quotes. This does 
>> > not work in tabular and I was unable to figure out any other mechanism. 
>> > Replacing the first " with \ did not work and neither did using single 
>> > quotes around the string. Is there a built in mechanism? The csv files in 
>> > question come from Microsoft Excel but I tested with a csv from Gnumeric 
>> > and see the same problem.
>> >
>> > cat testing.csv
>> > Junk,"Joe  ""Super"" Duper Guy",zsssy
>> > "More Junk",1,2
>> >
>> > ../portit pp testing.csv
>> >
>> > Error: (list->string) bad argument type - not a character: (#\")
>> >
>> > Call history:
>> >
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?
>> > utf8-srfi-14.scm:101: iset#iset-contains?   <--
>> >
>> > Thanks.
>> > --
>> > Complexity is your enemy. Any fool can make something complicated.
>> > It is hard to keep things simple. - Richard Branson.
>
>
>
> --
> --
> Complexity is your enemy. Any fool can make something complicated.
> It is hard to keep things simple. - Richard Branson.