Trim number fields as well as blank in SQL LOADER
From: Val <vegas_girlie_at_hotmail.com>
Date: 9 Jul 2003 06:42:34 -0700
Message-ID: <7d04f924.0307090542.50baaffa_at_posting.google.com>
Hi -
[Quoted] [Quoted] 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.
Date: 9 Jul 2003 06:42:34 -0700
Message-ID: <7d04f924.0307090542.50baaffa_at_posting.google.com>
Hi -
[Quoted] [Quoted] 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 - 15:42:34 CEST