|
I have a csv file with header row, " as text quoter and comma as column separator. When my file contains a space at the end, I will get this error: "character can't follow quote character " while data is begined with quote character." (note the 'invisible' display of the space character)
|
>character can't follow quote character
It means that it think it's illegal format. Please email us such a csv file with your jdbc url.
|
The 'illegal' format is the space at the end of the line. It's a really simple file:
"header1","header2"
"value1","value2"
|
|
And, of course the comment system won't show the space at the end of the "header1","header2" line :(
|
URL is:
jdbc:text:///../Import/quotes.csv?delayedClose=0&_CSV_Separator=\x3b&csvfileExtension=csv&_CSV_Quoter="&_CSV_Header=true&charSet=ISO-8859-1&decimalSeparator=,&dateFormat=yyyy-MM-dd&timeFormat=HH:mm×tampFormat=yyyy-MM-dd HH:mm&groupingSeparator=.&maxScanRows=0
|
|
Checked. It's nonstandard data, which stuff space after quoted string. We will support it soon.
|
|
You can download the latest package now.
|
Main
webmaster@hxtt.com