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

root (root@TeamInfinity.com) wrote: { I cannot find out how to import comma quote delimited text into Informix { if my life depended on it. We looked at dbload and got it to work ONLY { after converting our comma quote delimited ascii text file to single { character limited ascii text with much labor. comma quote delimited { ascii is very much a standard data format. There MUST be a way to import { comma quote delimited text into informix, but I sure could not find it ! { See we are trying to import dbaseIII and paradox files into informix by { first converting them to the WORLD STANDARD of comma quote delimited ascii { text, but informix's dbload seems to only allow importation of ascii text { that is delimited with a SINGLE character. Please tell us this is NOT so. First off, just because it's a standard, doesn't make it right. IF you have comma's in your text, it's difficult to use them as delimeters but the ascii | isn't often used in text. Maybe the WORLD STANDARD should change. (just my opinion) Anyway, try DBDELIMITER "," or try running a filter that changes all of your commas to pipes. { Thanks in advance, { root@TeamInfinity.com (Eric Sean Webber) -- gburnore@garys.arasmith.com ------------------------------------------------------------------------------- How you look depends on where you go. ------------------------------------------------------------------------------- | '۳''''''۳''''''''''''' Gary L. Burnore | '۳''''''۳''''''''''''' Director, Programming & Development | '۳''''''۳''''''''''''' Myers Information Systems, Inc. | '۳ 3 4 1 4 2 '' 6 9 0 6 9 ''' | Official Proof of Purchase ===============================================================================