i have a CHAR field , but i need to pull only numeric values or values with hypens only.
It is a zipcode field ,so i need to pull values something like this
90062 or values with hypen like 90062-3214 .
sometimes this field has values like , "extra","exist" etc...
Zipcode field length 10 datatype CHAR
can anyone help me to pull only zipcodes and not other values(i need to pull zipcode with 10 characters which has hypen also as i mentioned)
Thanks
Paddu
help on transformer logic
Moderators: chulett, rschirm, roy
You can use the DS/Basic "MATCHFIELD" function. If I remember correctly it even has an example on how to parse a ZIP code or SSN from a string. Look it up in the BASIC Programmer' Guide
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
InLink.ZipCode Matches "5N" : @VM : "5N'-'4N"
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.