Re: Trim number fields as well as blank in SQL LOADER
Date: 10 Jul 2003 06:26:33 -0700
Message-ID: <ecf365d5.0307100526.261ad391_at_posting.google.com>
vegas_girlie_at_hotmail.com (Val) wrote in message news:<7d04f924.0307090542.50baaffa_at_posting.google.com>...
> Hi -
> I have a problem in SQL LOADER where a NUMBER field is coming in with
> leading blanks or all blanks. how can i format it in the control file
> to either take the blanks or trim the value. A sample of the leading
> blanks is "| 2003" (Without the quotes) or simple with spaces like
> "| ". is there a way to specify the condtion where it would either
> trim or get rid of the leading spaces. I have tried putting both the
> LTRIM function as well the NULLLIF function but I still get an error
> message saying that it was an ivalid number.
>
> This is what I tried...
> FIELD_A NULLIF FIELD_A=BLANKS "LTRIM(:FIELD_A)"
> Thanks in advance!
What is FIELD_A? char varchar2....!
Michael Tubuo Ngong Received on Thu Jul 10 2003 - 15:26:33 CEST