RE: Importing a tab delimted text file?

Francis Try using this filter to convert your tab-delimited files to pipe-delimited files: sed -e 's/<tab char>/|/g' \\ -e 's/$/|/' $1 where <tab char> is a tab and $1 is your data file. Then use LOAD FROM datafilename INSERT INTO tablename to get the data into Informix. Hope this helps Sujit Pal DBA, Computer Sciences Corp. ---------- From: Francis Fang[SMTP:ffang@grover.printing.uiowa.edu] Sent: Friday, October 04, 1996 12:25 PM To: informix-list@rmy.emory.edu Subject: Importing a tab delimted text file? Hi folks, Is there an existing utility or script to take a tab delimited text file and import its contents into Informix Online? The text file originates from an old FileMaker database on a Mac. I've looked through the Informix stuff and can't find anything on importing data from outside source short of entering the data manually or having to write a shell script. Our setup includes Informix 4.10.UE1 running on a DECsystem 5000 (Ultrix). Thanks in advance! Frank.