Match_simple function not working

[Former Member]

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

[former_member600880]

Hi Suraj,

Is this issue resolved?

Can you send the script you used for comparing the pattern in Table2?

Regards,

Vijay

[Former Member]

What i understood from the above post is that you have to match the value 'NP' between two fields. If thats the case, have you tried index(input column name, search NP, start position as 1)?

Arun

[Former Member]

Hi Arun

Thanks for your reply

Its not only value 'NP'. It can be anything. I just gave an example to explain

Issue is  that When data is like this (1110-1132,2123-2250,NP) match_simple function not working. It gives some unknown error. But for all other cases match pattern is working.

[Former Member]

If anyone can look into this , it would be really helpful