Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

HTML Parse Query

Sidey1978
8 - Asteroid

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!

 

JonathanSharepoint Example Text.JPG

 

3 REPLIES 3
LordNeilLord
15 - Aurora

Hey @Sidey1978

 

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

 

regexreplace.PNG

Sidey1978
8 - Asteroid

@LordNeilLord

 

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

 

LordNeilLord
15 - Aurora

Regex is King!

Labels