Re: Sqlldr make double quote

On May 27, 7:38 am, Andrea <netsecur..._at_tiscali.it> wrote:
> Hi guys,
> i'm trying to import csv data with sql loader, the fields are
> delimited by ";" and there isn't any double quote in csv.
> When i import it adds in all data of first and last column double
> quotes "
>
> the control file is follows:
>
> load data
>  infile 'users.csv'
>  into table TAB_USERS
>  fields terminated by ";"
>  (COL1, COL2, ....)
>
> after the import the results is:
>
> COL1     COL2 ..    COL_LAST
> "text      ok             text"
>
> i don't understand why this behavior.
>
> thanks for any info.
> Andrew

You've posted your control file, now post the contents of 'users.csv'.

David Fitzjarrell Received on Tue May 27 2008 - 08:55:37 CDT