Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hi Bi family
Here i am struggling with a problem that is , i want to remove multiple characters in a text a column having .
And you can see the below image unwanted characters are there like <p> ,</p> ,<li>,</li>,<ul>,\,/ul>,<br> alot there .the problem is how do i remove those in one shot .Here thable has more than 2000 rows . so kindly help me on this
Thanks in advance
Solved! Go to Solution.
Hello,
You can leverage the PlainText function, it will just remove any html present in a string.
Best regards,
Alaa
Hello,
You can leverage the PlainText function, it will just remove any html present in a string.
Best regards,
Alaa
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.