Hi, The nullString is only used for non-delimited values. I will document this. Example:
A,B,C 1,NULL,X 2,,Y "3","NULL","Z" If the nullString is NULL, Column B of row 1 is null. Column B of row 3 is the literal "NULL". I don't plan to change this behavior. If you want to convert quoted empty strings to NULL, you need to convert it yourself. It doesn't make sense to add such a feature to H2 in my view, as it would make things more complicated for a very unusual use case. Regards, Thomas On Tue, Aug 7, 2012 at 1:17 AM, spacewiz <[email protected]> wrote: > Hello, > > I saw a number of posts describing similar problems, however was not able > to fine a solution... > > My program receives a tab-separated file from a 3rd party (which I cannot > modify) , which sometimes has double-quotes surrounding values. > I've attached a sample file to this email. I'm using CSVREAD to import the > file as an H2 database table for further downstream processing. > The problem is that the downstream logic depends on empty strings > (including "") being converted to NULL values. > > No matter what I try - I'm not able to convert empty strings represented > by two double-quotes "" between tabs to NULL values in database table :( > > I tried many things including passing ||CHAR(34)||CHAR(34)|| to nullString > parameter, but nothing works... > Looks like a bug? > ------- > DROP TABLE IF EXISTS sample_table; > > CREATE MEMORY TABLE IF NOT EXISTS sample_tab;le > AS SELECT * FROM CSVREAD('sample_tsv_with_double_quotes.csv',null, > 'caseSensitiveColumnNames=true charset=UTF-8 nullString="" fieldSeparator= > '); > > SELECT * FROM sample_table ; > ------- > (sample input file is attached) > > Any help is appreciated! > > Thank You! > Oleg > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/LmV7tuExSOkJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
