Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Trim number fields as well as blank in SQL LOADER
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!
Received on Wed Jul 09 2003 - 08:42:34 CDT