Re: .TXT files

> ->From: london@drawbax.attmail.com > ->Date: 2 Jun 94 19:30:07 GMT > ->To: informix-list@rmy.emory.edu > ->Subject: .TXT files > -> > ->Is there a way of loading data from a .TXT file > ->into informix database (ONLINE 5.0) ? These cheap DOS databases > unload with > ->those annoying commas as field separators with quotes around > ->character fields. Some of the character fields have actual commas > ->in them making this more of a headache to break the fields. Forgive > my > ->ignorance here but there must be a way to this short of sed or awk > scripts ??? > ->Maybe its so simple I'm missing it????? > -> > ->Many Thanks in advance for any and all replies. > -> > ->Brian London > ->IS Director > ->JM Rodgers CO., INC. > -> > ->london@drawbax.attmail.com > -> > It looks like your best bet would be to create a no-header, > no-footer, > no-page-break, fixed-column report from your dBASE, FoxPro, whatever.> > Then use dbload, with a control file to specify format, to load the > data > from the report. Another approach would be to produce the report so as to have some kind of fixed, known delimiter and then use the LOAD statement (SQL/ 4GL), telling Informix which delimiter you've used with the DBDELIMITER environment variable. This would be slightly easier than dbload, which requires you to set up parameter files which can be a bit tedious. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------- 44 272 742815