Removing HTML Script from data in Query Editor

[jchungfluentco]

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 creating a column with "?", and then concatenating but the first example wants shows that there are cells with styling before the question mark.

Thanks in advance!

Here are two examples:

Click <b>YES/b> if you watched the Super Bowl?

Did you watch the Super Bowl?<span style="font-size:14px !important; display: block;">Click YES if you did.</span>

<div id="disclaimer-1">You may be eligible for a free high five if you watched the Super Bowl.</div>

<style type="text/css" id="customCSS">
.Qid1 .answers{
position: relative;
top: -130px;
}

.Qid1 #disclaimer-54269{
position: relative;
top: 175px;
display: block;
width: 100%;
margin: auto;
text-align: justify;
font-size: 10px;
line-height: 16px;
color: #999;
}

@media all and (min-width: 600px){
.Qid1 .answers{
top: -120px;
}
.Qid1 #disclaimer-54269{
font-size: 12px;
line-height: 20px;
}
}

@media all and (min-width: 601px){
.Qid1 .answers{
top: -75px;
}
.Qid1 #disclaimer-54269{
top: 175px;
float: none;
display: block;
width: 100%;
}
}

@media all and (min-width: 900px){
.Qid1 #disclaimer-54269{
top: 85px;
}
}

</style>

[danilosg]

Hello my friend!

I´m having the same issue. Did You get a solution?

Thanks.

Dan

[danilosg]

Got it!

https://social.technet.microsoft.com/Forums/en-US/b080d122-14f0-43bc-8a86-f50cdf1c32d8/removing-html...

[jchungfluentco]

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]

Please see if this video helps: https://www.youtube.com/watch?v=6TQN6KPG74Q

If not, please come back here.