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!
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
Last edited by martindwilson; 03-16-2010 at 02:30 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Post deleted, was unable to suppress link parsing as expected
Last edited by 6StringJazzer; 03-16-2010 at 02:25 PM.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
I attatched the file instead.
[noparse]urls & other stuff[/noparse]was unable to suppress link parsing as expected
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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?
No, carry on. I was just responding to 6SJ.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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)))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you.
It doesn't work for me, would you like to attach the file in here?
probably you need ; not ,
but
here it is
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Now it works like a charm, thank you very much, highly appreciated!
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.Originally Posted by shg
Didn't know about the noparse tag, much obliged.
Sorry to derail the thread.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks