Forum Discussion
extract certain text from columns
Hi All,
I have a column that contains comments posted by different groups of people. Below image for reference.
I want to extract specific words from the comments, and then use that extracted columns as a category filter.
HI AbbasG ,
I suggest two approaches.
1) In Power Query, you can use Cognitive Services to automatically extract keywords (Tutorial: Integrate Power BI with key phrase extraction - Azure Cognitive Services | Microsoft Learn)
2) Use Power Query function like this example (Searching for Text Strings in Power Query • My Online Training Hub)
Marco
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
2 Replies
HI AbbasG ,
I suggest two approaches.
1) In Power Query, you can use Cognitive Services to automatically extract keywords (Tutorial: Integrate Power BI with key phrase extraction - Azure Cognitive Services | Microsoft Learn)
2) Use Power Query function like this example (Searching for Text Strings in Power Query • My Online Training Hub)
Marco
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
menglaro78 Hi thanks for the reply, it works but a bit difficult to set-up instead I managed it in SQL database through query.
