Question

REGEX formula to remove all text before a certain character

  • 3 March 2023
  • 3 replies
  • 3131 views

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.

3 replies

Userlevel 7
Badge +14

Hi @SC5 

Good question.

Try this instead…

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

Userlevel 6
Badge +8

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

Userlevel 7
Badge +14

@SC5

I asked ChatGPT and here’s the response: