Forum Discussion

jtpiazzamn's avatar
jtpiazzamn
Icon for Helper I rankHelper I
3 years ago
Solved

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 ...
Need Help
  • Shaurya's avatar
    Shaurya
    3 years ago

    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!

Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
3 years ago

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!