SQL*Loader Question

From: Scott C. <sdcairns_at_mindspring.com>
Date: Thu, 20 Aug 1998 16:33:01 -0400
Message-ID: <6ri180$s03$1@samsara0.mindspring.com>

I have a file to load which contains a $ amount field outputted by a different system that is in the format of:

9,999.99 (i.e., '$5000 = 5,000.00)

The file is delimited by "!" after each field but I need to figure out how to handle the above condition. ORA-01722 says 'invalid number' when it hits this field. The target column data type is NUMBER(9,2).

There's got to be some kind of format string to handle this right? Received on Thu Aug 20 1998 - 15:33:01 CDT