Yes, Tableau supports regex on Google Big Query, to learn more you can check out the Additional Functions. Were you able to get this regex to work on a test? I tried it out by just copying in your sample and it didn't return anything. When using the regex_extract function in Tableau you must specify only one capture group, so I think that is why you are getting that error. I'm not a regex expert but the following seemed to work for me:
I just added ?: to each group that you aren't actually trying to return and then added grouping parentheses around the whole thing.
Let me know if this works for you.
Thank you so much for your reply. It worked perfectly. I was planning on do a work around and create multiple calculated field for this issue but having in a single field is much better.Thanks again.