Being a curious chappie, I just took a quick look at how I'd solve this using non-regexp functionality. I did come up with a method, and it's as convoluted as many a regex. So, I decided to benchmark both solutions and to my
astonishment, my convoluted solution is consistently 10% (1M
runs of each, several times on db<>fiddle) faster than the simple regex one.