pattern match



1 comment

  • Official comment
    Alan Mark

    Hi Mallinath,

    Can you please clarify what you want your result to be if the strings meet the match criteria?

    Is there going to be a third column providing the terms for matching?

    Will the first word in column A always be the match term?  If it is an option is to split the first word using our SPLIT function.  

    Other functions which may be helpful here are CONTAINS, CONTAINS_IC, MATCHES.

    If you provide some additional detail on the column data and what you're trying to achieve with the matching - we may be able to provide some more specific guidance.

    Comment actions Permalink

Please sign in to leave a comment.