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 -
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

This message: [ Message body ]
Next message: JN: "How to retrieve latest record when date and time are separate ?"
Previous message: Tom Urbanowicz: "Trigger and DML INSERT on separate table"
Next in thread: michael ngong: "Re: Trim number fields as well as blank in SQL LOADER"
Reply: Jan Gelbrich: "Re: Trim number fields as well as blank in SQL LOADER"
Reply: michael ngong: "Re: Trim number fields as well as blank in SQL LOADER"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message