Replace characters between paranthesis and parenthesis with a comma multiple times one row

[cowatson]

Hi all,

I have a value in a row field that i am trying to remove all the characters in the field that are between inequality signs ("<" and ">") as well as the inequality signs and replace them with a "," multiple times in one field.

Example:

From this: <tr><td><a href="/hockey/64475/10">Blades of Steel</a></td><td>146</td>

To this: ,,,Blades of Steel,,,146,

I have been trying to do this with Regex Replace and Trim but not having much luck (i just get an output of <> right now).  Any thoughts?

Thank you,

Court

[lmorrell · Accepted solution]

Hi @cowatson 

Workflow is attached

The below RegEx formula should return your result

regex_replace([Field1], '<.*?>', ',')

This is looking for any pattern with an open inequality sign and a following closing inequality sign, and deletes those signs plus everything in between. 

Hope this helps! 

[cowatson]

Slow. Clap.  Thank you sir.