Forum Discussion
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...
I transformed it into a proper function here :-) https://github.com/ImkeF/M/blob/master/Library/Text.RemoveHtmlTags.pq
I transformed it into a proper function here :-) https://github.com/ImkeF/M/blob/master/Library/Text.RemoveHtmlTags.pq
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!
Please see if this video helps: https://www.youtube.com/watch?v=6TQN6KPG74Q
If not, please come back here.