Support Article
Retrieve array of values using the isMatch function
SA-41403
Summary
The isMatch function matches a string with a large string and returns a single Boolean value of True if it matches and False if it does not.
For example:
isMatch("BALCOUTPUTSUM","*BALC*") - true
isMatch("OUTPUTSUM","*BALC*") - false
The requirement is to compare a single string value with an array of strings and return an array of Boolean values.
For example:
isMatch({"BALCOUTPUTSUM","METHODTEST,CDMBALC"},*BALC*")- true,false,true
Resolution
Here’s the explanation for the reported behavior:
Use the isinarray function instead of isMatch function to compare a single string with an array of strings and return an array of boolean values.
Tags:
Published November 10, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.