html tags

[PudduckD]

Hi Can anyone help, why is my query returning the following font info at the begining and end? how do i remove these html tags? <font face="Arial">DCH OOS and cant get any from any supplier what would you like us to do? Darren </font>

[PudduckD · Accepted solution]

sorry missed a couple of curly brackets = Html.table ([HTML Text],{{"plaintext",":root"}}) 

[PudduckD]

Hi thanks for your answer, i managed to figure it out and yes i did use a custom column but used the following formula = Html.table ([HTML Text],{{"plaintext"",":root}}) 

[rajendraongole1]

Hi @PudduckD - can you please share more details with sample data . as per my understading, do you want to remove the HTML tags ?

if yes in power query editor we can do it, via different data transformations by creating new custom column  and using Text.Replace() m functions:

eg.,= Text.Replace(Text.Replace([YourColumnName], "<font face=""Arial"">", ""), "</font>", "")

or by using DAX Resolved solution:

Solved: How to remove html tags from some rows. - Microsoft Fabric Community

Hope it works