In this case I did just know I could use Recode's Replace String with Regex to do what you asked.
In general, https://regex101.com/ is the one I use when testing regex, just be careful with company data as always.

LLMs are also quite good with regex, so you can try asking from them.
-Jarmo