Delete a specific part of a string

[TarekIMEX]

Hello everyone, I want to delete a specific part of a string.

I have a column 'Comment'. Within this column I have texts values of this type :

<p><span style="color: #333333; background-color: #ffffff;">Units reduced due to space surrender</span></p>

I want to delete the "HTML part". To be more clear, I want to delete all the stuff between "<*>".

Thank you all.

[usmanbashir]

@TarekIMEX - Take a look at this discussion. It should have what you need.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Regex-Remove-HTML-Containers/t...

[binu_acs · Accepted solution]

@TarekIMEX 

[TarekIMEX]

It worked ! Thank you.

Can you explain to me how REGEX_Replace works please ?

I'm not sure to well understand <[^>]*

Thank you

[binu_acs]

@TarekIMEX 

This regular expression will match any text within < and > brackets, including the brackets themselves, and replace it with an empty string. Here's what each part of the regex pattern does:

<: Matches the opening angle bracket.
[^>]*: Matches any character that is not a closing angle bracket >, zero or more times.
>: Matches the closing angle bracket.

 After applying this regex, all text within the <> tags will be removed from the text.