Re: Importing a tab delimted text file?

I have done this on a number of occasions. My preferred method is to use an editor to replace TAB with comma or the pipe symbol. The file can then be imported with DBLOAD or the SQL LOAD command. In theory the edit operation should not be necessary but I have had difficulty on some platforms in setting DBDELIMITER to TAB. > 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. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc