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

root@TeamInfinity.com (root) writes: >I cannot find out how to import comma quote delimited text into Informix >if my life depended on it. [...] > Thanks in advance, > root@TeamInfinity.com (Eric Sean Webber) A couple of one-liner filters (presuming you have UNIX): : # qa2sql # convert QA files to SQL load file sed 's/\\",\\"/|/g' | tr -d "\\"" | sed 's/$/|/' : # sql2qa # convert SQL unload output to QA input. sed -e 's/|$/\\"/' -e 's/^/\\"/' -e 's/|/\\",\\"/g' -Mike