Hi, Yes, as escape character, but also as field delimiter.
Regards, Thomas On Fri, Mar 1, 2013 at 8:13 AM, Noel Grandin <[email protected]> wrote: > It treats double quote as an escape character by default > > http://h2database.com/html/**grammar.html#csv_options<http://h2database.com/html/grammar.html#csv_options> > http://h2database.com/javadoc/**org/h2/tools/Csv.html#** > setEscapeCharacter_char<http://h2database.com/javadoc/org/h2/tools/Csv.html#setEscapeCharacter_char> > > > On 2013-03-01 01:14, Jeff Steinkamp wrote: > >> I am having some issues with CSVREAD when the field separator is the | >> charter and the field contains a quote character ("). It appears it is >> interpreting the quote character as an additional field separator. Here is >> the SQL statementI am using. >> >> insert into tenmaster(select * from csvread('C:\ProgramData\** >> 10DataMgr\batch\tenmaster.csv'**,'TEN|CALLSIGN|FCCNAME|NAME|** >> ADDR1|ADDR2|CITY|STATE|ZIP|**CNTRY|CNTRYCDE|EXPR|EXPR_DATE|** >> LSTCHANGE|CERT| >> LIFEDATE|SKDATE|MEMBER|STATUS|**FAMILY1|FAMILY2|FAMILY3|** >> FAMILY4|FAMILY5|NOMAIL|**ADDRCHNG|BIRTHYR|NOTE|** >> PREVCALL1|PREVCALL2|PREVCALL3|**PREVCALL4|PREVCALL5|NEWS|**EMAIL|COMMENT|VOTED >> ','charset=UTF-8 fieldSeparator=|')); >> >> >> Is there something else I need to add to the CSVREAD statement to >> preclude this from happening? >> >> >> -- >> 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 >> h2-database+unsubscribe@**googlegroups.com<h2-database%[email protected]> >> . >> To post to this group, send email to [email protected]. >> Visit this group at >> http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> >> . >> For more options, visit >> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >> . >> >> >> > -- > 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 > h2-database+unsubscribe@**googlegroups.com<h2-database%[email protected]> > . > To post to this group, send email to [email protected]. > Visit this group at > http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> > . > For more options, visit > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> > . > > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
