Solved

Strip Filename from a websit url

Posted on 2010-08-21
2
414 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

733 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