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
Logic Help
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
(Len(InLink.String) = 4) And (Left(InLInk.String,1) = "S") And IsValid("integer",Right(InLink.String,3))
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.