Forum Discussion

unicorn's avatar
unicorn
Regular Visitor
9 years ago
Solved

Robust function to remove HTML tags

Hi, I have a column of HTML data that I need to display as text. I need to get rid of all HTML tags and substitute reserved HTML characters. I was trying to recursively remove all HTML tags first. Th...
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Just change the "|" into "<"

     

    rmvAll = if Text.PositionOf(rmvOne, "<") >= 0 then @removeAll(rmvOne) else rmvOne

     

    Otherwise you may get unexpected results if the string contains < or > that are not part of a HTML tag.

     

    If you are interested, I can share my code that only removes tag pairs, i.e. </...> strings preceded by the same without /: <...>

pstaggers's avatar
pstaggers
Icon for Advocate II rankAdvocate II
4 years ago

Hi, I am using this custom function to remove all HTML tags:

 

(TableToSearch as table, ColumnToSearch as text) =>
Table.TransformColumns(TableToSearch, {ColumnToSearch, each Table.FirstValue(Html.Table(_ ?? "", {{"text",":root"}}))})

 

The initial idea came from Chris Webb's blog:

https://blog.crossjoin.co.uk/2019/06/09/removing-html-tags-from-text-in-power-query-power-bi/

 

Coalescing Operator (??) to prevent errors on nulls was an addition courtesy of Ben Gribaudo.