Originally posted by: SystemAdmin

I got a fundamental question.i have a email field which should not accept any numbers at its domain field.(i have divided email into 2 parts.one with name second with domain.) can anybody tell me how i can apply restrictions for this at type tree level.thanks in advance.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I didn't test this, but it may get you going....
SIZE(LEAVENUM(WORD($,"@",-1)) ) =0

WORD($,"@",-1) is grabbing everything to the right of the "@".

LEAVENUM() is leaving only numbers.

SIZE() is the size in bytes of those numbers.

And the rule says that the size of all the numbers to the right of the @ must equal 0.

Sound's good in a thought, I'm just not sure it'll work.

Message was edited by: rep
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Actually i want to apply restriction feature in type tree for this.
i donot want to use any component rule.Are there any suggestions on this.i want to know how to apply restriction in these cases.
THANKS
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: NancyR

Component rules are in the type tree. Also, I'd use ISALPHA:
ISALPHA( WORD($,"@",-1))
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

thanks verymuch. It is working.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

I'm not sure which one is working, but ISALPHA() looks better. It would probabaly use less resources.
I never used that one, good to know.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange