Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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>
Solved! Go to Solution.
I transformed it into a proper function here 🙂 https://github.com/ImkeF/M/blob/master/Library/Text.RemoveHtmlTags.pq
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hello my friend!
I´m having the same issue. Did You get a solution?
Thanks.
Dan
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |