Forum Discussion
Remove HTML tags from Column
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?
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!
1 Reply
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!