I need assistance with embedded content for a translation project

Hello! I am a complete rookie when it comes to these kinds of things. I have a bunch of YAML files and I set the embedded content processor to excel, however I do not know the correct regex codes to remove the unnecessary brackets, tags, etc. They serve their purpose to tell the game what graphic or effect to use, so they serve no purpose for translating, and are annoying, haha.

Here's some text examples of how I want things to look like:

Brussel sprouts, potato salad, and lots of \c[3]ORANGE JOE\c[0].

I would like to remove \c[3] and \c[0].

Piles of assorted foods stored in foil, cling film, and plastic containers.\!

I would like to remove \!

\aub\{\Com[2]\QUAKE[1]W-What!? \!Where!? \!\Com[2]Get it off!!\}\QUAKE[0]

I would like to remove \aub\{\Com[2]\QUAKE[1] , \! , Com[2] , \} , \QUAKE[0]

\berI dunno... \!I just felt like doing it.

I would like to remove \berI and \!

\n<TV GIRL>There's a new show that just started airing! \!<br>It's a little dramatic, but pretty interesting...<br>\!I'm already hooked!

I would like to remove \n , <TV GIRL> , \! , <br> 

I would also like to remove this text from the translation, as it serves its purpose to tell what face graphics to use: MainCharacters_

Would any regex experts be able to help? Thank you so much in advance! 

emoji