How to use REGEXP MATCH

0 votes
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.
Apr 1, 2019 in Tableau by Nithin
860 views

1 answer to this question.

0 votes

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.

answered Apr 1, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by ffdfd
• 5,550 points
2,864 views
0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,560 points
788 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sal ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
1,871 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,560 points
17,324 views
0 votes
1 answer

What is the difference between REGEXP_MATCH() and REGEXP_EXTRACT()?

Hi, REGEXP_MATCH() AND REGEXP_EXTRACT() are both used for ...READ MORE

answered Apr 1, 2019 in Tableau by Cherukuri
• 33,030 points
2,586 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,832 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,561 views
0 votes
1 answer

how to use/access Json data in Tableau?

Hi Sindhu, 1. Double click on Json on ...READ MORE

answered Mar 19, 2019 in Tableau by Cherukuri
• 33,030 points
3,784 views
0 votes
1 answer

How to use stored procedures in Tableau?

Hi Sindhu, Stored procedures are used to write ...READ MORE

answered Jun 10, 2019 in Tableau by Cherukuri
• 33,030 points
9,567 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP