I’m trying to extract currency from a text string but I get false returned.I’m using [[:punct:]]currency[[:punct:]]:[[:punct:]]\s*(\w+) to extract GBP from the below text string:{"product":["IR Forum \u2013 AI & Technology Europe - Corporate second release rate (Amount: 0.00 GBP, Quantity: 1)"],"currency":"GBP","tax":"0.00","total":"0.00","coupon":"VIPGUEST","stripeData":Any advice?

Hi @PaulOCHere’s a different approach:Action: Formatter > Text > SplitSplit by: “currency”:”Segment Index: LastAction: Formatter > Text > SplitSplit by: “Segment Index: First

Regex not extracting currency from a text string

I’m trying to extract currency from a text string but I get false returned.

I’m using in:punct:]]currencyre:punct:]]:t::punct:]]\s*(\w+) to extract GBP from the below text string:

{"product":u"IR Forum \u2013 AI & Technology Europe - Corporate second release rate (Amount: 0.00 GBP, Quantity: 1)"],"currency":"GBP","tax":"0.00","total":"0.00","coupon":"VIPGUEST","stripeData":

Any advice?

Page 1 / 1

Hi @PaulOC

Here’s a different approach:

Action: Formatter > Text > Split
- Split by: “currency”:”
- Segment Index: Last
Action: Formatter > Text > Split
- Split by: “
- Segment Index: First

Hi Troy,

Thanks for your quick response - I will try this tomorrow.

Kind regards

Paul

@PaulOC

If you want to use regex, try this regex:

"currency"\s*:\s*"(\w+)"

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded