Issues with keyword search using regex_match

Question

Hi community

i am trying to identify key words from a list of transaction data  and have been experimenting with the regex_match function.  However, i have come across an issue where the key word is picking up a wildcard of the key word contained in other words

by way of example, the regex match function uses the key word "IGA" (a local supermarket franchise) but is returning additional words that contain "IGA" such as "SPIGA" .

For example the data set could include

IGA North Sydney

IGA Lane Cove

IGA Burwood

VIA DIA SPIGA

How can i update this expression (or utilise other tools) to ensure i am only picking up transactions that contain an exact match to the key word? In the above example, i would only want IGA North Sydney, IGA Lane Cove and IGA Burwood to be identified and not "VIA DIA SPIGA"

many thanks

Ladarthure · Accepted Answer

Hi @gavin_chin, here is the updated RegEx, you just needed to add somethign to specify it's a word you are looking for : regex_match([vendor], ".*(\ |\|\|\|\|\).*")

philipmannering · Accepted Answer

Or