Remove HTML tags from Column

[jtpiazzamn]

I have a colmn which contains HTML tags as an example: <p><strong>NEW IDEA</strong></p> 

It would be great if we could just PARSE the text out from the HTML. So the end result of this line would be "NEW IDEA" (without the "" of course). 

I have seen lots of examples, but can't find one that would work for me. Would I create a new column which have a DAX equation? 

Thanks in advance. HEY Microsoft - you can parse out date from a long date field, can't you parse out html? 

[Shaurya · Accepted solution]

Hi @jtpiazzamn,

You can do this transformation in Power Query by extracting the text between delimiters and using advanced options to skip the first occurence of '>'.

I tried this and got "NEW IDEA" (without the "" of course). For your reference:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wiik1MDBOLgBTqRBOcUlRfl46RMTPNVzB08XVESKjjywFFYJqVYqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Tags = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Tags", type text}}),
    #"Extracted Text Between Delimiters" = Table.TransformColumns(#"Changed Type", {{"Tags", each Text.BetweenDelimiters(_, ">", "<", 1, 0), type text}})
in
    #"Extracted Text Between Delimiters"

Works for you? Mark this post as a solution if it does!