Re: Does anyone know how to import a tab delimited file.

Marc,

Have you tried using X'hexstr' where hexstr is the hex for tab?

Chris

Marc Weinsock wrote:
>
> I tries using '\t' as the terminator character but that did not work
> in sun solarias.
>
> INFILE 'data'
> REPLACE
> INTO TABLE IMP_LOCAL_DETAIl
> FIELDS TERMINATED BY '\t'
> TRAILING NULLCOLS
> (
> ACCOUNT_NUMBER char (20)
> , BILL_NUM char (20)
> , CHARGE_NUM char (20)
> , SERVICE char (20)
> , CHARGE_DATE date (11)
> , TIME char (20)
> , NUMBER_CALLED char (20)
> , CITY char (20)
> , STATE char (20)
> , CLS char (3)
> , MINUTES decimal external
> , COST decimal external
> , SERVICE_TOTAL_MINUTES decimal external
> , SERVICE_TOTAL_COST decimal external
> , CHARGE_NUM_TOTAL_MINUTE decimal external
> , CHARGE_NUM_TOTAL_COST decimal external
> , BILL_NUM_TOTAL_MINUTES decimal external
> , BILL_NUM_TOTAL_COST decimal external)
>
>
Received on Thu Dec 16 1999 - 17:23:19 CST