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. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\