Extract 2, 3, 4 or 5-digit number from string

[Jim]

I have a list of URLs where some contain the parameter "categoryid="
with either a 2, 3, 4, or 5 digit number. I need to extract that
number, as an integer, into a neighboring column. I need a routine or
function to help with this - something along the line of making the mid
function smart enough to recognize numbers and adjust the length value
so it only takes the numbers. And if it doesn't find "categoryid",
then leave the cell blank.

TIA,
Jim

 

[Tom Ogilvy]

Assuming the URL's are in Column A beginning in A1 put in this formula using
Ctrl+Shift +Enter to enter it rather than just enter since it is an array
formula. Then drag fill down the column.

=IF(ISNUMBER(FIND("categoryid=",A1)),MAX(IF(ISNUMBER((MID(A1,FIND("categoryi
d=",A1)+11,{1,2,3,4,5}))*1),(MID(A1,FIND("categoryid=",A1)+11,{1,2,3,4,5}))*
1,"")),"")

 

[Jim]

Many thank, Tom.

Jim