Forum Discussion
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=...
Hi Anonymous ,
Try this code:
Text.Combine(List.Transform(Html.Table([Column1], {{"div", "span"}})[div], each Text.Clean(_)), " ")
camargos88
Community Champion
Community ChampionHi Anonymous ,
Try this code:
Text.Combine(List.Transform(Html.Table([Column1], {{"div", "span"}})[div], each Text.Clean(_)), " ")
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
Anonymous ,
Do you have any different character in this column from the previous post ?
Actually yeah, Just checking and this was an issue my end. Thanks for the brilliant solution.