Reject the records if it is not numeric values
Posted: Thu Jun 24, 2010 2:45 am
Hi,
am getting the data from the source file is eight characters
(it may have characters as well as Numbers). Ex: OMNI6408
While loading into target table i need to filter if first three letters are characters.
(If first 3 letters are numbers then only I need to load)
Pl give me the solution.
Thanks,
am getting the data from the source file is eight characters
(it may have characters as well as Numbers). Ex: OMNI6408
While loading into target table i need to filter if first three letters are characters.
(If first 3 letters are numbers then only I need to load)
Pl give me the solution.
Thanks,