scripting - To create control file for loading data into table -

I have 1 data file, where 1 column contains some data 'D' with 'D' prefix 'exists '. Table data in D. Loading of these figures in the table should be '1234' without including. Need to remove the prefix and load the data. There is no way to do this way. Thanks in advance.