Re: Importing a tab delimted text file?

> 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. You can try setting the environment variable DBDELIMITER="\\t" and then using dbload or the LOAD command in ISQL/DBAccess. Or you can vi your datafile and try :1,$s/<tab>/|/g (where <tab> means press the TAB key). Then save the file and dbload it. You won't need to set DBDELIMITER. HTH. > Our setup includes Informix 4.10.UE1 running on a DECsystem 5000 > (Ultrix). Whooo! State of the art! :-) -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | Oracle isn't the answer. Oracle is the question, and the answer is "no". | +------------------------------------------------------------------------------+