Extract Number from a String after two trailing slashes

[suprag]

My url's are of the following format:

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;">[URL="http://www.localhost.com/prod/1108/some-other-desc"]hxxp://www.localhost.com/prod/1108/some-other-desc[/URL]  => Extract 1108
[URL="http://www.localhost.com/product4/1102/some-5-other-desc"]hxxp://www.localhost.com/product4/1102/some-5-other-desc[/URL]  => Extract 1102

</code>

I want to extract the number after the two trailing slash. How do I do it? Let us assume this string is at "C2"

 

[István Hirsch]

Try this:

=TRIM(MID(SUBSTITUTE(C2,"/",REPT(" ",200)),800,200))

 

[steve the fish]

Assuming they are always after the 4th slash and are numeric:

=0+TRIM(MID(SUBSTITUTE(C2,"/",REPT(" ",99)),99*4,99))

 

[suprag]

Both solutions worked. Thanks so much!!

 

[István Hirsch]

You are welcome.