I want to use CSVREAD to read in a tab-separated values file, but the way I
do it, leading spaces seem to get trimmed from the fields that are read.
I am using something like
INSERT ... SELECT ...
CSVREAD('test.tsv', UPPER(STRINGDECODE('field1\tfield2\tfield3')),
STRINGDECODE('charset=UTF-8 fieldSeparator=\t escape=
fieldDelimiter='))
But when the TSV file contains two different lines like this:
val1\tval2\tval3
val1\t val2\tval3
they will both be read in into rows like for the first of these lines (no
leading spaces in the second field).
How does this happen and how can I prevent it?
Is there anything else to be aware of so that the field values are read and
preserved absolutely identically to what is in the TSV file?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
