Re: Sqlldr make double quote
Date: Tue, 27 May 2008 07:52:32 -0700 (PDT)
On May 27, 3:55 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> 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
sorry, the problem was file text conversion from windows to unix. thanks Received on Tue May 27 2008 - 09:52:32 CDT