Skip to main content
Solved

Extract 0-1000 number from a url after a pattern

  • June 4, 2023
  • 2 replies
  • 34 views
B
Forum|alt.badge.img+2

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

Best answer by Stephen_Orr1

Try this

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

2 replies

S
Forum|alt.badge.img+18
  • Stephen_Orr1
  • Inspiring
  • Answer
  • June 4, 2023

Try this

REGEX_EXTRACT({url}, 'Bnumber%5D=(\\d+)')
B
Forum|alt.badge.img+2
  • Brian_Moran
  • Author
  • New Participant
  • June 4, 2023

Try this

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

Worked perfectly! Thanks a million @Stephen_Orr1 

Terms & ConditionsAccessibility statement