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

Question

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: Blades of Steel146 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 Answer

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!