Can someone please explain the difference between Match and Search and how to structure them within Codeless to make them work in a similar way to a LIKE Statement in SQL with wildcard letters like the percent sign “%”?
Thanks!!
Hi @William_Lee !
“Search” block searches only for first encounterence of specified pattern and return position on which it was located.
“Match” will return list of all parts from the string which were matched by pattern.
They are based on the corresponding JS functions
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/match
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/search
To emulate “LIKE” behavior I would recommend you to use “Search” block since you interested only in presense of pecified pattern.
Regards, Andriy
