http://forums.enterprisedb.com/posts/list/3.page JForum - http://www.jforum.net
I need to import data delimited with "|". This is easy enough, but one of the fields contains variable length text (as with most of the other fields) that also contains pipes in the data all contained withing quotation marks. One is able to specify text delimiters when importing CSV files, is there a way to achieve this for my pipe delimited file?. Lines in my files look some thing like this:

34|2009.08.12 08:30:21|12-32-1-1|0x00001213|...lots of fields...|"absdre|default{123|3231|345}"|1|2

I would rather not do a search and replace in the files. Can anyone make a suggestion?

Thanks
Louis]]> http://forums.enterprisedb.com/posts/preList/2133/7963.page http://forums.enterprisedb.com/posts/preList/2133/7963.page GMT
You can try with

copy table1 from 'filename' delimiter '|' CSV quote as '"';

Thanks
Sreelatha]]> http://forums.enterprisedb.com/posts/preList/2133/7975.page http://forums.enterprisedb.com/posts/preList/2133/7975.page GMT
"copy table1 from 'filename' delimiter '|' CSV quote as '"';" worked for the import.

Thanks
Louis]]> http://forums.enterprisedb.com/posts/preList/2133/8003.page http://forums.enterprisedb.com/posts/preList/2133/8003.page GMT