Hi,
I was trying to do a csvread of the file attached. It has the delimiter as
CTRL-A(i.e \u0001).
This is the input
12^Asandeep
As mentioned above delimiter is not ^A . it is \u0001
The expected output of the following statement is
select * from csvread('test.csv','ID|NAME','charset=UTF-8
fieldDelimiter='\u0001');
Expected output:
ID | NAME
12 | sandeep
Actual Output
ID | NAME
12\u001sandeep | NULL
Please let me know if am doing something wrong.
thanks,
-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/-/7AeEMFqdA_cJ.
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
