Formatting text with special characters and pattern

[Saravanan13]

Hi all,

I am trying to pull data from SharePoint. facing some formatting issue. I would require the output as shown in the output column. can anyone assist on this

[Robin_McIntosh · Accepted solution]

@Saravanan13 - Here's a post that you may want to try since the sample data you have contains HTML.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Regex-Remove-HTML-Containers/td-p/4522...

[gaoa · Accepted solution]

Hi @Saravanan13 here's something I built. hope it helps. :)

[Saravanan13]

It worked thank you so much

[Saravanan13]

Thanks Robin