Question

How to use REGEXP_MATCH() to find products with same company name?. My data consists of product information like company, product name, place, expiry, manufactured date. I want to display products from many products and goods.

Answer 1

Hi,

Create a calculated field with code like this,

Product_match

REGEXP_MATCH([Product Name],'/w*-/w*')

For example if you are searching for product Goodday-ahv5e5dsd  followed by some id, then \w is used to denote a character and * denotes 0 or more occurrences of any character.

If your product name have any special characters such as ], . ,* , $ then you must prefix with \ to make it as a normal character.

\w and \s denote words, space, for matching pattern.

Hope this helps you.