Add column with list of keywords found in text column using M code

[pbi_data]

Hi,

In power query I have a text column with phrases. I want to categorize the phrases by one or more keywords found in the text. The keywords are defined in another table.

I would like the found keywords to be added as a table/list in a new column.  The reason I want a table returned is, that I intend to expand this. same as https://community.fabric.microsoft.com/t5/Desktop/Power-query-Add-column-with-list-of-keywords-found....

I am using a function in m code(photo attached) to extract all rows that match the words from the list.

ID	text	keywords to be searched for	table to be returned
111	standard price for the product	standard price	standard price
112	standard for the product	standard	standard
113	price for the product	price	price

I have an issue with this solution 

When i expand the table  if there is a text that contains 'price',  I can see also the rows with 'standard price'.

This is not what I want. 'Price' and 'Standard price' should be separate categories( the one shouldnt be included in the other). In other words , if the text contains price w/o th word standard, this shouldnt be included in standard price.

Thank you.

[Anonymous · Accepted solution]

Hi @pbi_data ，

Please try:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Mahesh0016]

@pbi_data Please can you share your EndOutPut? Thank You!!