Solved: Re: Removing HTML tags complex

Anonymous · ‎07-14-2020

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=""ExternalClass9254C4569EB64875A3EF9B11D59EE81C""><div style=""font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);"">EDRM@Work consultant completed testing and confirmed additional work needs to be completed

and charged for. <p style=""margin-right:0cm;margin-left:0cm;font-size:12pt;font-family:"Times New Roman", serif;margin-top:0cm;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background-color:rgba(255, 226, 223, 0.5);"">Business continued with UAT? and liasing with project team and

issues encountered all parties continued to work together to resolve. <p style=""margin-right:0cm;margin-left:0cm;font-size:12pt;font-family:"Times New Roman", serif;margin-top:0cm;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background-color:rgba(255, 226, 223, 0.5);"">Scanner issue requires instructions from Test on how to configure to work with the software, but this will only give CSU one working scanner.  The other scanners are not compatible with Windows 10 following the upgrade from Win 7 to Win 10. <p style=""margin-right:0cm;margin-left:0cm;font-size:12pt;font-family:"Times New Roman", serif;margin-top:0cm;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background-color:rgba(255, 226, 223, 0.5);"">Continued to feedback the ongoing test issues and new issues to Test with zero or slow and poor response on the problems being encountered<p style=""margin-right:0cm;margin-left:0cm;font-size:12pt;font-family:"Times New Roman", serif;margin-top:0cm;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background-color:rgba(255, 226, 223, 0.5);"">Continue to endeavour to get Test to provide free

consultancy to assist IT in configuring the settings globally for users and all

the other issues raised as a result of the testing.?<p style=""margin-right:0cm;margin-left:0cm;font-size:12pt;font-family:"Times New Roman", serif;margin-top:0cm;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background-color:rgba(255, 226, 223, 0.5);"">Review of the major issues raised in testing took place with IT.  PM will be issuing an Exception Report to PCC Governance, with options on the best way forward. as Go Live date of 7/8 August is not looking feasible, but Test

have advised the next available date for Go Live would be January 2021!<p style=""margin-right:0cm;margin-left:0cm;font-size:12pt;font-family:"Times New Roman", serif;margin-top:0cm;margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;background-color:rgba(255, 226, 223, 0.5);""> </div></div>"

Into this:

"EDRM@Work consultant completed testing and confirmed additional work needs to be completed and charged for. Business continued with UAT and liasing with project team and issues encountered all parties continued to work together to resolve. Scanner issue requires instructions from Test on how to configure to work with the software, but this will only give CSU one working scanner. The other scanners are not compatible with Windows 10 following the upgrade from Win 7 to Win 10. Continued to feedback the ongoing test issues and new issues to Test with zero or slow and poor response on the problems being encountered. Continue to endeavour to get Test to provide free consultancy to assist IT in configuring the settings globally for users and all the other issues raised as a result of the testing. Review of the major issues raised in testing took place with IT. PM will be issuing an Exception Report to PCC Governance, with options on the best way forward. as Go Live date of 7/8 August is not looking feasible, but Test have advised the next available date for Go Live would be January 2021!"

I can't seem to figure out a way to get it convert nicely. Any suggestions would be be welcomed.

camargos88 · ‎07-14-2020

Hi @Anonymous ,

Try this code:

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

camargos88 · ‎07-14-2020

Hi @Anonymous ,

Try this code:

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

rubulsahu · ‎01-05-2024

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.

Anonymous · ‎07-14-2020

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?