Reject the records if it is not numeric values

[nagarjuna900]

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,

[ray.wurlod]

Code: Select all

Alpha(Left(InLink.TheCode,3))

as a constraint expression.