Skip to Content
author's profile photo Former Member
Former Member

Match_simple function not working

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2012 at 06:41 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2012 at 04:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

  • Posted on Jul 21, 2016 at 11:54 AM

    Hi Suraj,

    Is this issue resolved?

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

    Regards,

    Vijay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.