Regex Trim everything before special character

[Bobbins]

Morning,

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

Field1

Lots of *Gobblegook

*Heretoo

Maybe not here

I have this:

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

Thank you

[binuacs · Accepted solution]

@Bobbins 

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

[binuacs · Accepted solution]

@Bobbins Another option using formula

[Bobbins]

@binuacs Ah, so close. Thank you for the assistance and showing a different way of doing things!