Extract 0-1000 number from a url after a pattern

[Brian_Moran]

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

[Stephen_Orr1 · Accepted solution]

Try this

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

[Brian_Moran]

Worked perfectly! Thanks a million @Stephen_Orr1