Skip to main content

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%5D=1&start_date=2023-01-01

In this case, the result would be 39

Some help on the formula would be greatly appreciated!

 

Cheers,

Brian

Try this

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

Try this

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

Worked perfectly! Thanks a million @Stephen_Orr1 

Reply


Terms & Conditions