Question
How to create a single wildcard search filter that allows searching by multiple keywords?
How to create a single wildcard search filter that allows searching by multiple keywords?
"(?=.*" + REPLACE([Search Terms (Comma Separated)], ',', ")(?=.*") + ").*"
REGEXP_MATCH([Product Name],[Regex String (AND)])
"(" + REGEXP_REPLACE([Search Terms (Comma Separated)], ',', '|') + ")"
REGEXP_MATCH([Product Name],[Regex String (OR)])