https://www.red-gate.com/simple-talk/sql/t-sql-programming/tsql-regular-expression-workbench/#fourth
I find myself continually doing a 'we're not worthy' bow to the people at www.red-gate.com. Below is their Regex.Replace function for SQL, it works GREAT.
I copy it here because it's easier to find when I'm in a hurry... I use this site all day long in production coding.
RedGate, you rock.