The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:0cm 0cm 7.5pt;"><span style="font-family:"segoe ui", sans-serif;font-size: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:0cm 0cm 7.5pt;"><span style="font-family:"segoe ui", sans-serif;font-size:10.5pt;">IV circled on the pic</span></p><p class="MsoNormal"> <br></p><p><br></p>
Ideally I want to remove anything between <>, but i'm struggling to see how.
Thanks
Chris
Hi @chydewf1,
Can you please post an example of the expected output of the sample you posted (just to help clarify).
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