Substitute, find and mid

[outlet.ee]

I have image paths in a cell, I need to get the image names only to the other cell

path
http://bla-bla-bla/dir1/dir2/image_n...&variable2=456

or

http://bla-bla/dir11/dir22/dir33/image_name.jpg

(the path names and structures vary)

I need to get the image_name out into another cell. So I need a function which says 'remove everything starting from 5th "/" and everything starting from first "?".

I was able to remove the first portion in one formula and the last portion in another one but couldn't combine them into one formula.

Any help greatly appreciated!

[martindwilson]

got some proper examples in an excel sheet coz the forum truncates those . they show as this in properties but just what do you want from the first one the second is easier =TRIM(RIGHT(SUBSTITUTE(A2,"/",REPT(" ",25)),20))

xhttp://bla-bla-bla/dir1/dir2/image_name?variable=123&variable2=456x]
http://bla-bla/dir11/dir22/dir33/image_name.jpg

[6StringJazzer]

Post deleted, was unable to suppress link parsing as expected

[outlet.ee]

I attatched the file instead.

[shg]

was unable to suppress link parsing as expected

[noparse]urls & other stuff[/noparse]

[outlet.ee]

I am sorry, I do not get this. I attatched the excel sheet instead, the links are not necessary anymore. Or should I post a new thread now?

[shg]

No, carry on. I was just responding to 6SJ.

[martindwilson]

well if only in that format with following _ or ?
=IF(ISNUMBER(FIND("?",B2)),TRIM(RIGHT(SUBSTITUTE(LEFT(B2,FIND("?",B2)-1),"/",REPT(" ",30)),25)),TRIM(RIGHT(SUBSTITUTE(LEFT(B2,FIND("_",B2)-1),"/",REPT(" ",30)),25)))

[outlet.ee]

Thank you.
It doesn't work for me, would you like to attach the file in here?

[martindwilson]

probably you need ; not ,
but
here it is

[outlet.ee]

Now it works like a charm, thank you very much, highly appreciated!

[6StringJazzer]

[noparse]urls & other stuff[/noparse]

Just for the record, I quoted the original post then unchecked "Automatically parse links in text." However, the coding underlying the paste explicitly parsed the links anyway. When I tried to edit it, I discovered that the "Automatically parse links in text" option is not available in edit-existing-post mode. Didn't know about the noparse tag, much obliged.

Sorry to derail the thread.