Solved

Strip Filename from a websit url

Posted on 2010-08-21
2
404 Views
Last Modified: 2012-05-10
Hi

I have a long list of URL's of images on my website that I want to import into my database. I have downloaded the list of images into excel and they appear as follows:-

http://www.mywebsite.com/images/image1.jpg
http://www.mywebsite.com/images/image-two.jpg
http://www.mywebsite.com/images/imagethree.jpg
http://www.mywebsite.com/images/image4.jpg

I want to use excel to prepare a csv file to import into my databse but I only want the image name rather than the whole URL... thus I want a formula/macro which would return:-

image1.jpg
image-two.jpg
imagethree.jpg
image4.jpg

I have over 2000 records to import!
Can this be done somehow?

Thanks for the help!!
0
Comment
Question by:sagarh
2 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 500 total points
ID: 33491875
=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,"/","|",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

Kevin
0
 

Author Closing Comment

by:sagarh
ID: 33491887
Thanks! works perfectly.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question