Re: HOW in the HECK can we import comma quote delimted ASCII !!!????

> > Thanks in advance, >} >} root@TeamInfinity.com (Eric Sean Webber) > >The Informix Guide to SQL Reference (9/92), pg 4-8 tells of the DBDELIMITER >env variable for use with dbload. I don't know if you can make it a >multi-character string, but it is worth a try. >If that doesn't work, then abandon the "WORLD STANDARD" and use the >"Informix Standard". :) > > __________________________________________________________________ > It should not be that complicated to replace the quotation marks and commas for the vertical bar ('|') which is the default delimiter for informix. First load the file into a text editor (EDIX for Unix is pretty good). Then, get rid of the quotation marks with a search and replace feature (unless you want to do it manually one by one). Then, replace the commas with |. You have to make sure that the row ENDS with a | and it DOES NOT start with a |. I have done it many times with no major problems. You may need a text editor which can load a big file. There are some for DOS, Windows, and, of course, Unix.