Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Removing HTML tags complex

Hi all,   Thanks for looking. I’ve already tried the customer column “HTML.Table” it’s it’s still really messy. In short, I need help converting something similar to the following:   "<div class=...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this code:

     

    Text.Combine(List.Transform(Html.Table([Column1], {{"div", "span"}})[div], each Text.Clean(_)), " ")

     

     

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

Try this code:

 

Text.Combine(List.Transform(Html.Table([Column1], {{"div", "span"}})[div], each Text.Clean(_)), " ")

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey That's kinda odd, I can see on your screenshot that that has worked for you, however, with my data it's throwing in "_x000D_" (4 times) here and there? apart from that, it works perfectly. Any suggestions on how to avoid it adding"_x000D_" or shall I just use a find and replace to shift it? 

    • camargos88's avatar
      camargos88
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous ,

       

      Do you have any different character in this column from the previous post ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Actually yeah, Just checking and this was an issue my end. Thanks for the brilliant solution. 

  • rubulsahu's avatar
    rubulsahu
    Frequent Visitor
    2 years ago

    HI camargos88 I hope you can help me here. I have a same issue where I want to remove html tag. but I use the formula provided by you its giving me blank 

    Can you please advise what I am missing here.