Finding and replacing words in sentences

Finding and replacing words in sentences
Zoltán Tóth
Zoltán TóthMay 13, 2022 06:48 AM
I have sentences (English and French) and I have specific words in a vocabluary. I would like to highlight …
1. Finding and replacing words in sentences

Zoltán Tóth
Posted May 13, 2022 06:48 AM
I have sentences (English and French) and I have specific words in a vocabluary.

I would like to highlight words in the english sentences when they are in the vocabluary and I would like to highlight the whole French sentence when there is a vocab match in the english one.

I want to do this with the help of an HTML visual.

I transformed my vocab column to look like this: <mark>word</mark> so If there is a match I would like to replace the specific word(s) in the sentences with the formatted words.

With the french sentences I might make a new formatted column and I would like to replace the whole value to the formatted one If there is a match. ( I guess finding the sentences with a match and giving it a prefix and a suffix would be less memory and computing consuming, but i’m not sure)

We made a solution for words, however we did It in M and we need to do it in DAX on the fly. (With Text.Replace)

Thank you in advance for your help!

Kind regards,

——————————
Zoltán Tóth
——————————

2. RE: Finding and replacing words in sentences

Bronze Contributor
James Watts
Posted May 17, 2022 03:43 AM
This might get you half way :

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200002426?tab=overview

——————————
James Watts
Business Intelligence Analyst
——————————