Hi,
I am trying to use csvread to read from the testfile attached. The file has
CTRL-A (\u0001) as delimiter in between fields.
The statement I used is
select * from csvread('test.csv','id, name','charset=UTF-8
fieldDelimiter=\u0001');
Expected Output:
ID | Name
12 | sandeep
Actual output:
ID | Name
12\u0001sandeep | null
which means it is not picking \u0001 as the delimiter.
Please let me know how to handle CTRL-A(\u0001) as delimiter while doing
csvread of a file.
thanks in advance.
-sandeep samudrala
--
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/-/wiIhlY10Y3AJ.
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.
12sandeep
