InstantDB: importing files with quotes in them

Subject: InstantDB: importing files with quotes in them

From: "Hamish Currie" <hamish-instantdb@vp.list.to>

Date: Wed, 20 Sep 2000 15:11:28 +1000

Hi,

I need to import data containing single quotes from a text file. I tried quoted all the string fields with double quotes, however it seems that this dosen't work.

for example I want to import data like:

1,"hmm", "data"

1,"a dog's life","blah"

3,"even more data","test"

I have an import_schema file that looks like this

ColNameHeader=False
CharacterSet=ANSI
Format=CSVDelimited

Col1=Id Integer

Col2=Data1 Char Width 30
Col3=Data2 Char Width 30

I am calling it from sql1.txt like this

e IMPORT DataDump FROM "data.txt" USING "schema.txt";

I get errors like

java.sql.SQLException: Unexpected EOF reached. Possible reason: mismatched quotes.
        at org.enhydra.instantdb.db.tokenList.parseTokens(tokenList.java:244)
        at org.enhydra.instantdb.db.tokenList.reset(tokenList.java:115)
        at org.enhydra.instantdb.db.FileImporter.getNextRow(FileImporter.java:290)
        at org.enhydra.instantdb.db.SQLProg.compile_import(SQLProg.java:874)
        at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:238)
        at org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
        at org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.java:103)
        at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:410)
        at java.lang.Thread.run(Unknown Source)

Is it possible to import data with single quotes in it?

Thanks in advance

cherio

Hamish Currie