Help

Extract 0-1000 number from a url after a pattern

Topic Labels: Formulas
Solved
Jump to Solution
537 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brian_Moran
5 - Automation Enthusiast
5 - Automation Enthusiast

From the below URL, I am attempting to extract the number that comes after the pattern "page%5Bnumber%5D="


https://api.leadfeeder.com/accounts/133259/leads?end_date=2023-01-01&page%5Bnumber%5D=39&page%5Bsize...

In this case, the result would be 39

Some help on the formula would be greatly appreciated!

 

Cheers,

Brian

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

Try this

REGEX_EXTRACT({url}, 'Bnumber%5D=(\\d+)')

See Solution in Thread

2 Replies 2
Stephen_Orr1
10 - Mercury
10 - Mercury

Try this

REGEX_EXTRACT({url}, 'Bnumber%5D=(\\d+)')

Worked perfectly! Thanks a million @Stephen_Orr1