I believe that Quotes are used to define a field that has a delimeter in
it. This is the case with CSV files. In CSV you can escape a quote
using a slash like this \". Give that a try, I have not worked much
with Tab Delimited files so I can't say for sure without pouring over
the source.
Tim Troup wrote:
Hi,
I removed the first double quote character and the data got inserted
without error.
From this experimentation I assume the double quote character is the
default stop delimiter?
Any suggestions as to the best way to get data such as this inserted?
I could parse the tab delimited data and remove all double quote
characters then somehow insert them again once they are in the
database but this seems rather clumsy and error prone.
Any advice would be greatly appreciated.
Cheers, Tim
On 12 Jan 2007, at 12:07, Tim Troup wrote:
Hi,
I am trying to load a tab delimited text file into a database table
in derby 10.2.1.6 using the following command in ij:
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE
(null,'pg_synonyms','/Users/troup/data/biomint/pg_synonyms','
',null,null,0);
However I keep getting the following error:
ERROR 38000: The exception 'java.sql.SQLException: Data found on line
8,238,195 for column 2 after the stop delimiter.' was thrown while
evaluating an expression. SQLSTATE: XIE03: Data found on line 8238195
for column 2 after the stop delimiter.
What is the default stop delimiter?
I have analysed the file contents and this line has double quotes
round a word in the column two data:
"Gu" protein
no other line preceding this one has double quotes round any word so
this made me suspect this was what is causing the load error.
Any advice would be greatly appreciated.
Best regards,
Tim Troup
