I’m trying to use the regexmatch function in Google Sheets to match the item “hip hop” in the bolded cases in the lists below:
– atl hip hop, dirty south rap, hip hop, pop rap
– dirty south rap, hip hop, pop rap
so what I’m after is basically standalone hip hop in between commas (or at the beginning or end of string) – without any prefix or postfix.
Here’s my formula but its not matching correct:
=REGEXMATCH(LIST,"(\W|^)(,\ship\shop,)(\W|$)")
pjgei is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1