Hello.
I need to run keyword research and segment my keywords based on their search intention.
Right now I need to use multiple expressions in expr argument in =RegexpIsMatch function.
Based on my previous knowledge on python and JS I've written this formula to check if a string matches my expression:
=regexpismatch(A2,"Online|Shop"&"grocery|Bakery")
But the output doesn't work properly. the & operator worked as OR operator. for example with this formula "grocery" keyword Becomes TRUE.
how can I use multiple expressions in this function?!!!
Hi,
The "&" operator concatenates the two strings so the regex pattern becomes: "Online|Shopgrocery|Bakery"
It should work with two separate regexpismatch, combined with AND():
=And(regexpismatch(A2,"Online|Shop"),regexpismatch(A2,"grocery|Bakery"))