Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm new to "M" and I have a question that I think should be pretty simple but I can't find the right answer anywhere.
I am connected to a SharePoint List through Power BI and a few of the columns in the data set are coming across like this: "<div class="ExternalClass7DF52B6F7B0440629625A19FD571B46D"><p>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</p></div>"
I changed the text to "X's" for confidentiality. Anyway, How can I remove all the HTML script from all these columns and rows so that it just gives me the comments? I can't find anything about how to remove this from the entire data set so I'm hoping someone here can help.
I also have a column or two with <?xml> tags too, but should also only show the comments between the <> tags.
HELP!!
Hi @cjwilson80 ,
The code might help you.
(HTML as text) => let Source = Text.From(HTML), SplitAny = Text.SplitAny(Source,"<>"), ListAlternate = List.Alternate(SplitAny,1,1,1), ListSelect = List.Select(ListAlternate, each _<>""), TextCombine = Text.Combine(ListSelect, "") in TextCombine
There is a similar thread you can reference.
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |