Question

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?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+14

Hi @SC5

Good question.

Try this instead…

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

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

+8

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

+14

@SC5

I asked ChatGPT and here’s the response:

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor

Sign up