LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Extract image paths from within html in a column

I've been trying to figure this out and just have been unable to. It's important that I figure out how to extract image paths that are in html code in all cells in a column. The image paths are not full url's. Here's an example:

<img src="images/stories/example.jpg" width="450" height="300" alt="Example" /

...and that code would be in the html code of an entire page and the html code is within a cell in a long column. What I need to figure out is how to exact this from that image code:

images/stories/example.jpg

...and that's it. Normally I would just Find & Replace something like "images" with a "|" and then copy the column into notepad and then paste it back into a new column in Excel and then open the text import manager thingy and then specify "|" and then I would have a column that starts with /stories/example.jpg. Then I would do the same thing with "jpg" and then I would have "/stories/example." then I would just add "images to the front of that and "jpg" to the back and be done with it, but this method isn't working because of the html code or something I don't know. So any suggestions would be GREATLY appreciated. Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tough one - image and embedded html document xp Excel Programming 3 May 27th 09 03:10 AM
Image in comment not showing in html salto Excel Discussion (Misc queries) 0 August 24th 07 01:16 PM
extract text from html files Glowinafuse Excel Discussion (Misc queries) 3 May 31st 05 06:23 AM
How can I extract the Text from a GIF Image? Please help! Jas Excel Programming 6 March 11th 05 02:24 AM
Excel interacting with HTML Image Maps Nigel[_7_] Excel Programming 0 March 8th 05 09:49 AM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"