In case someone else stumbles across this and is missing a final answer: this kind of thing is now (since when actually?) possible by adding an additional “g” modifier flag to the match function… also see this post here to figure out the correct string syntax… Expression REGEX_(MATCH|REPLACE) documentation