help on transformer logic

[paddu]

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

[kumar_s]

You can check if ascii value for each character lies under the range of nubmers or '-'.

[ArndW]

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

[ray.wurlod]

Code: Select all

InLink.ZipCode Matches "5N" : @VM : "5N'-'4N" 

used as a constraint expression or in an If..Then..Else expression

[paddu]

[quote="ray.wurlod"][code]InLink.ZipCode Matches "5N" : @VM : "5N'-'4N" [/code]
used as a constraint expression or in an If..Then..Else expression ...[/quote


Ray,

thank you very much. i used the expression as constraint and it worked.


Thank You
paddu