Originally posted by: SystemAdmin

=IF (MEMBER(MID(Text Data General Element:.:In1,22,2),{"BG","BR","BF","BX","BU","BS","BD","CQ","CN","CT","CA","CM","CH","CX","CP","CF","CI","CJ","CR","CY","CL","CW","DZ","DR","EA","FT","GR","GI","GA","GS","TG","HU","IN","JR","JU","KG","KE","DK","LT","LB","LF","LO","LY","MR","ME","ML","MM","MP","MT","OZ","PA","PR","PC","PK","PT","PX","QT","QU","RE","RL","SJ","ST","SH","SV","SO","SF","SI","SM","SY","TB","TH","TN","TO","TX","YD","24","26","27","L ","M ","SQ"} ),NONE,"7101")

When I am trying this rule even if the MID function evaluates to something thats within the flower braces it still gives the output as "7101"
Can anyone tell me what I am doing wrong.

Thanks,
Sai.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Hi

I've tried this command and it works fine for me in V6.7. The commands are case sensitive, could that be the problem.

Tim
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Try putting your MID function in a separate data element so you can see exactly what the result is, or in addtion to your 7101 put the MID function there as well... NONE, "7101-(" + MID(....) + ")" so you can see the value. Surrounding the MID output with () helps you see unprintables.

The other approach you might consider taking is to create a simple text file with these values in it (sorted) and have it as an input card. Then use LOOKUP or SEARCHUP to test. This provides better flexibility (add/remove values without code change) and visibility (valid codes are not buried in a rule).
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange