csv-parser
Wednesday, 4 December 2013 · 3 messages
LJ
Lars Johnsen4 Dec 2013 12:58 #
Hi all
When importing CSV files, it seems that BaseX is parsing fields for balanced bracketing and quotes (a single quote or bracket causes trouble). Is it possible to turn that off, so that files are processed based only on delimiter? I couldn't find any information in the documentation.
All the best,
Lars
CG
Christian Grün4 Dec 2013 18:28 #
Hi Lars,
Quoted text · Lars Johnsen · 4 lines
> When importing CSV files, it seems that BaseX is parsing fields for balanced > bracketing and quotes (a single quote or bracket causes trouble). Is it > possible to turn that off, so that files are processed based only on > delimiter? I couldn't find any information in the documentation.
I’ve just added such an option to BaseX. Could you please give us some feedback if it does what you expect?
Thanks,
Christian
[1] http://docs.basex.org/wiki/CSV_Module#Options
[2] http://files.basex.org/releases/latest/
LJ
Lars Johnsen4 Dec 2013 22:39 #
Fabulous, that fixed it!
The lines with a single quote " in them are fine, as well as those with a single left parenthesis (. The data come from a SQL database with human entered data in freetext fields, so things aren't always in balance.
The new file browser with the editor is nice too!
Best,
Lars
2013/12/4 Christian Grün <christian.gruen at gmail.com>
Quoted text · Christian Grün · 17 lines
> Hi Lars, > > > When importing CSV files, it seems that BaseX is parsing fields for > balanced > > bracketing and quotes (a single quote or bracket causes trouble). Is it > > possible to turn that off, so that files are processed based only on > > delimiter? I couldn't find any information in the documentation. > > I’ve just added such an option to BaseX. Could you please give us some > feedback if it does what you expect? > > Thanks, > Christian > > [1] http://docs.basex.org/wiki/CSV_Module#Options > [2] http://files.basex.org/releases/latest/ >
Written for BaseX 7.7. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery