Skip to main content

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? 

 

Hi @SC5 

Good question.

Try this instead…

Use Formatter > Text > Split (split at :t: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: