Skip to main content
Question

Use Formatter Regex to Extract Words from a Parenthesis

  • January 24, 2024
  • 3 replies
  • 120 views

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 25, 2024

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


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 25, 2024

@lightdao 

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

\((.*?)\)

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 25, 2024

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