Use Instr to pull image names out of Memo field
Posted on 2003-10-23
I have a table containing an id column and a content column (memo field). Each row may contain imbedded links to images, there may be more than 1 link in each row. I need to extract the image name, it is either in jpg, bmp or gif format. Here is an example of the material.
Determine which of the following is worth the most money.
<img border="0" src="/pictures/clip_quarter.gif"> <img border="0" src="/pictures/clip_dimes.gif"> <img border="0" src="/pictures/clip_nickel.gif">
<img border="0" src="/pictures/clip_penny.gif">
The result needs to be a table with the id filed, which will not be unique, and 1 row for each image. Any help will be sincerely appreciated. This level of query is beyond my expertise. Thanks Brent