Hi,
Thanks I will give your suggestion a try.
Do you propose I edit the tab delimited text file and escape all
double quote characters by inserting a backslash prior to trying to
load the data into the database?
Cheers, Tim
On 12 Jan 2007, at 14:22, Paul J DeCoursey wrote:
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
