Skip to Content
0
Former Member
Aug 22, 2012 at 01:08 PM

Match_simple function not working

551 Views

Hi

I have a scenario in which I have to compare a table column value from the ranges value of another table column. I am using match_simple function to achive this.

DIFFERENT SCENARIO

1. Table1 contains value 'NP' and Table2 contains (2250,NP) value. In this case match_simple function is working

2. Table1 contains value 'NP' and Table2 contains (2220,2211-2213,2241,2242,2250,NP) value. In this case also match_simple function is working.

3. Table1 contains value 'NP' and Table2 contains (1110-1132,2123-2250,NP) value. But, In this case also match_simple function is not working and I am getting error.

For pattern search I am changing values to the suitable format used by match_simple function e.g. I am changing value 2220,2211-2213,2241,2242,2250,NP to value {2220;[2211..2213];2241;2242;2250;NP}

But for the 3rd case, I am getting error.

Kindly let me know if someone has used this function.

For alternative,If anyone can provide me the format for these values to be used with match_pattern or match_regex, it would be really helpful.

I can check whether other 2 functions are working with same value or not. Thanks

Regards

Suraj garg