HTML Parse Query

Hi all

I am using a SharePoint register as my source data. One of the fields is a set of free text containing a list of action points for staff to go off and remedy.

I'm getting all the HTML markers on my output. So far I've had no joy trying to parse the actual text out as it appears on the SharePoint Site. Please could someone shed some light on this for me?

I have attached the SharePoint view of the text and the output that I'm currently getting. Ideally I'd just like to keep the text in bold.

Cheers all!

Jonathan Sharepoint Example Text.JPG

HTML Parse Query.xlsx

Output

Parse

Sharepoint

Accepted answers

Try using regex in replace mode and replace everything between < > with nothing:

All comments

Try using regex in replace mode and replace everything between < > with nothing:

Ah great that worked a treat. And it was soooo much simpler than all the attempts I'd made.

Thanks so much for your help.

Cheers

Jonathan

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703