Re: sqlldr and TAB

unfortunately not

but i tested it with "press tabulator".
then it works a bit

i have

v1 tab tab v3

but i get

f1 v1
f2 v3
f3 -

with "," everything wors just fine, but my source data contains , and ; and so on

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> schrieb im Newsbeitrag news:3AD1C6E7.69A175BD_at_exesolutions.com...
> Is it fixed length?
>
> Daniel A. Morgan
>
>
>
> Carsten Landeck wrote:
>
> > Hi
> > I have a beginner question:
> > In the *.ctl file I have the option "FIELDS TERMINATED BY"
> > I'm using tabulators, but '\t' doesn't work.
> >
> > My data-source file is ok
> >
> > -> Value TAB value TAB value CR <-
> >
> > LOAD DATA
> > INFILE 'import.tab'
> > INTO TABLE imp
> > INSERT
> > FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
> > (ObjClass,
> > ...
> > )
> >
> > The result is, that the whole tupel is stored in the first field.
> >
> > Has someone a hint?
> >
> > Carsten
>
Received on Mon Apr 09 2001 - 17:29:51 CEST