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 <[email protected]> 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 <[email protected]> > 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.
test.csv
Description: MS-Excel spreadsheet
