Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
chydewf1
Frequent Visitor

Remove text between delimiters

Hi,

 

I have some text in a column that has a series of farmats detailed between delimiters - I want to clean it up.

 

<p style="margin&#58;0cm 0cm 7.5pt;"><span style="font-family&#58;&quot;segoe ui&quot;, sans-serif;font-size&#58;10.5pt;">The upper interesting text i want is here, bla, bla, bla etc etc!
face as the M2.5 CSK are under a lot of force clamping to the face plate, we
</span></p><p style="margin&#58;0cm 0cm 7.5pt;"><span style="font-family&#58;&quot;segoe ui&quot;, sans-serif;font-size&#58;10.5pt;">IV circled&#160;on the pic​</span></p><p class="MsoNormal">​&#160;<br></p><p><br></p>

 

Ideally I want to remove anything between <>, but i'm struggling to see how.

 

Thanks

 

Chris

3 REPLIES 3
Phil_Seamark
Microsoft Employee
Microsoft Employee

Hi @chydewf1,

 

Can you please post an example of the expected output of the sample you posted (just to help clarify).

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Here you go...

 

The upper interesting text i want is here, bla, bla, bla etc etc!
face as the M2.5 CSK are under a lot of force clamping to the face plate, we

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.