DSXchange

Hi,

I am trying to find a solution to implement the following logic in Datastage

regexp_like(upper(POSTAL_CODE), '^S[0-9][0-9][0-9]$')

from the above line I can find the starting value of column, but how can I find the end value in a column.

Any suggestions would be greatly helpful.

Thanks

Kumar

Or, if (when) you have the Data Rules stage (version 8.7 or later) you can test using a direct matches_regex rule.