Andrew Jensen wrote:
I take you are using HSQL and you know about the select into a text
table, just in case.
I have a test datbase with a table named Table1
The table has three columns, one is an integer and the others are varchar
If I execute the following statement
select * into TEXT "tmp3" from "Table1"
I end up with the file tmp3.csv in the same directoryt as my ODB file.
This is the contents
0,9999,New Value
1,1002,cat
2,2001,pigeon
3,2002,hawk
4,3310,turtle
5,3318,snail
So, now we just have to figure out how to make the ',' turn into a '/t'.
ah - thanks a lot. didn't know any of that.
I can convert the commas simply with a regexp in vi.
thanks,
Kae
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
