Forum Discussion

Frequent Visitor

8 years ago

Solved

Removing HTML Script from data in Query Editor

Hi everyone, I'm trying to remove all text between < and > including the carrots from a column in Query Editor. I thought about splitting the column with the ? being the delimiter, then creat...

Tips and Tricks

Tutorial Requests

ImkeF
8 years ago
I transformed it into a proper function here :-) https://github.com/ImkeF/M/blob/master/Library/Text.RemoveHtmlTags.pq

Community Champion

8 years ago

Web.Page("your html") or this technique:

https://social.technet.microsoft.com/Forums/en-US/473b2c06-7845-4df7-846a-d350ee84e942/remove-html-tags-from-a-column-in-power-query?forum=powerquery

Maybe ImkeF has some more tricks up her sleeve.

ImkeF
Community Champion
8 years ago
I transformed it into a proper function here :-) https://github.com/ImkeF/M/blob/master/Library/Text.RemoveHtmlTags.pq
- jchungfluentco
  Frequent Visitor
  8 years ago
  Thank so much for transforming into a proper function!
  
  I just have some beginner level follow-up questions on how to implement the M script.
  
  The data file I'm using is calle "SurveyResponses_Age&Vertical"
  Should I be replacing Source = Text.From(HTML) to Source = Text.From(SurveyResponses_Age&Vertical) ?
  
  Is it best to use the Advanced Editor, and if so, how what's the proper syntax for that?
  
  Thanks!
  - ImkeF
    Community Champion
    8 years ago
    Please see if this video helps: https://www.youtube.com/watch?v=6TQN6KPG74Q
    If not, please come back here.
- adamsjw65
  Regular Visitor
  8 years ago
  I am connecting to a SharePoint Online List. Is there a way to use this code to remove the HTML Script for the data when I load? Thanks.
  - danilosg
    Regular Visitor
    7 years ago
    Hello my friend!
    
    I´m having the same issue. Did You get a solution?
    
    Thanks.
    
    Dan
- sampathK
  Microsoft Employee
  7 years ago
  Awesome , you made my day very easy and simple. Thank you so much...