REGEX formula to remove all text before a certain character

I’m struggling with the Regex code in a formatter Zap.

I’m trying to remove all text/characters before the : just leaving all the text that follows the :

Ive tried the excel regex formula but its not computing.

example:

data pulled is

user.name: Accepted

I want it to only produce Accepted to push to my google sheet.

can anyone help me figure out the formula?

Be the first to reply!

Hi @SC5

Good question.

Try this instead…

Use Formatter > Text > Split (split at :[:space:]) and keep the last segment.

Troy’s suggestion is good. If you want to use regex then .*\:(.*) should work. I tried that on your example and it worked.

@SC5

I asked ChatGPT and here’s the response:

Sign up