topic Re: Regex Remove HTML Containers in Alteryx Designer Desktop Discussions

Regex Remove HTML Containers

Afammy — Thu, 13 Jun 2024 22:35:28 GMT

My input includes html containers and I need to remove them (characters and html commands) and leave just the actual text values:

<div>How do I remove the html tags?</div><br><div>Looking forward to the answer.</div>

Need to see: How do I remove the html tags? Looking forward to the answer.

Thank you.

Re: Regex Remove HTML Containers

MarqueeCrew — Wed, 01 Feb 2017 16:52:04 GMT

@Afammy,

I took a stab at this for you using your sample container entry.

I added a space between the text. You might want to have a PIPE delimiter left behind instead of the space. Please try this and let me know if it helps.

Trim(
          Regex_Replace(
                                    Regex_Replace([HTML_Container],"<.*?>",'|'), "[|]{1,}",
                                                              ' ')
                                    )

Trim(
          Regex_Replace(
                                    Regex_Replace([HTML_Container],"<.*?>",'|'), "[|]{1,}",
                                                              '|')
                                    )

I've got the two sets of code (space and pipe replacements) above.

Trim() gets rid of any spaces at the front or end of your field.

Regex_Replace uses a wild card for all sets of data enclosed by <> and replaces them with a '|' pipe.

Regex_Replace uses a search for multiple pipes and replaces them with a single pipe.

At least for your test data it seems to work.

Cheers,

Mark

Re: Regex Remove HTML Containers

Afammy — Wed, 01 Feb 2017 17:14:51 GMT

Thanks @MarqueeCrew! Worked like a charm. You also gave me a mix of formula and regex to learn and use moving forward.

Re: Regex Remove HTML Containers

halfling — Wed, 16 May 2018 06:18:28 GMT

Thanks! This was just what I needed to solve my problem.

Re: Regex Remove HTML Containers

wale_ilori — Mon, 27 Aug 2018 05:29:16 GMT

Thank you!! Just what I needed right now.

Re: Regex Remove HTML Containers

AshimaPahwa — Fri, 17 Feb 2023 05:57:50 GMT

Thankyou so much for the solution.

Re: Regex Remove HTML Containers

sdodero — Thu, 27 Jul 2023 12:44:51 GMT

Thanks Amazing!