Regex Trim everything before special character

Question

Morning,

A simple one which despite searching still isn't easily found. I want to regex trim everything upto and including the *. E.g.

Field1Lots of *Gobblegook*HeretooMaybe not here

I have this:

[code].*(\*)[/code[ which on Regex101 does highlight everything upto the *, but then i am stuck!

Thank you

binu_acs · Accepted Answer

@Bobbins

REGEX_Replace([Field1], '.*\*(.+)', '$1')

binu_acs · Accepted Answer

@Bobbins Another option using formula