db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Troup <Tim.Tr...@ed.ac.uk>
Subject Re: Data found after the stop delimiter
Date Fri, 12 Jan 2007 14:32:52 GMT
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
>>>
>>
>>
>
>


Mime
View raw message