(You can obviously leave off the

REGEXP_REPLACE

part if your transid's are all numeric and get better performance. I put it in the get rid of the prefixes.)