iam trying load the data from text file.
Data text file look like this...
00100| |H|H174|.001MF/2KV | | | |DISC CAP
00100| |A|A143|.01MF100V | | | |P/N C4-100V / .01UF
00100| |A|A40 |.033MF | | | |P/N 22804918 **T/S

Third column is number datatype in oracle db. i want to suppress first alphabetic character and load the remaining number data. is there any function to load the number data.

My ctl look like this

OPTIONS (BINDSIZE=1024000)
LOAD DATA
INFILE 'd:\data\fr-parts-record_ldr.dat'
INTO TABLE f_parts_record
REPLACE
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '+++'
TRAILING NULLCOLS
(
LOCATION_NO,
SITE_LOCATION,
BIN_NUMBER COLUMN OBJECT
(
BIN_A,
BIN_B
),
PART_NUMBER,
PART_TYPE,
SUB_TYPE,
SUB_PTNUM,
PART_DESCRIPTIOn
)