Question

Use Formatter Regex to Extract Words from a Parenthesis

  • 25 January 2024
  • 3 replies
  • 27 views

Userlevel 1

I would like to extract the word “San Francisco” WITHOUT the parenthesis.

 

 


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 @lightdao 

Since Formatter steps are free you could do this in 2 steps.

Formatter > Text > Split

Split at (

Keep the last segment

Then

Formatter > Text > Split

Split at )

Keep the first segment

Userlevel 7
Badge +14

@lightdao 

If you wanted to use Formatter > Text > Extract Pattern, try this:

\((.*?)\)

 

Userlevel 7
Badge +14

@lightdao 

Also, you can use AI to help you format data.

When mapping variables between Zap steps, there is an AI option to format data.

Give that a try.