Hello I was reading a recent post by you on how to extract certain data from a cell. I was wondering if you would also know how to do the following. I have an ecommerce store and need to extract certain data from my dealers. Here's and eg.
Cell info
End of Cell data<p><br /><img height=351 width=500 border=0 src=http://www.tpg.com/paintball/images/T68/T68_True_Target_Marker_LF.jpg /><br /><br /><br /><img height=371 width=500 border=0 src=http://www.tpg.com/paintball/images/T68/T68_True_Target_Marker_LB.jpg /><br /></p><table width=500 cellspacing=0 cellpadding=0 border=0 id=table1> <tbody> <tr> <td><font face=Arial size=2>The T68 True Target Package is all metal construction. This unit is built for fast rapid action. Built with the <a href=http://www.tpg.com/os/product_info.php/products_id/63>True Target Point Sight</a> you are in complete control of each shot..</font></td> </tr> </tbody></table><p><font face=Arial size=2><br /></font></p><p><font face=Arial size=2 color=#ff0000><font face=arial size=2><b>Available Options</b></font><table height=293 id=table2> <tbody> <tr> <td height=9 width=75 valign=center><b><font face=Arial size=2>Option 1:</font></b></td> <td height=9 width=409><font face=Arial size=2>There are 9 different air options to choose from: <a target=_new href=http://www.tpg.com/paintball/t68_air_system.html><font face=Arial size=2 color=#0000ff>View the different air system available here</font></a></font></td> </tr> <tr> <td height=12 width=75 valign=center><b><font face=Arial size=2>Option 2:</font></b></td> <td height=12 width=409><font face=Arial size=2>Your marker comes with a 14" Tactical barrel, you can upgrade your barrel to rifled version for better performance. You can </font><a target=_new href=http://www.tpg.com/paintball/os/barrel-systems-tactical-rifled-barrel-c-22_220_388.html><font face=Arial size=2 color=#0000ff>view the different barrels and specs here</font></a></td> </tr> <tr> <td height=40 width=75 valign=center><b><font face=Arial size=2>Option 3:</font></b></td> <td height=40 width=409><font face=Arial size=2>With this 200 rounds hopper adaptor and you can change out your magazine fed marker to use a hopper</font></td> </tr> <tr> <td height=11 width=75><b><font face=Arial size=2>Option 4:</font></b></td> <td height=11 width=409><font face=Arial size=2>This kit comes with all the o-rings to completely rebuilt your marker</font></td> </tr> <tr> <td height=2 width=75><b><font face=Arial size=2>Option 5:</font></b></td> <td height=2 width=409><font face=Arial size=2>This tool kit has all the tools for you to service your marker</font></td> </tr> <tr> <td height=21 width=75><b><font face=Arial size=2>Option 6:</font></b></td> <td height=21 width=409><font face=Arial size=2>Extend your manufacture warranty to 3 years</font></td> </tr> <tr> <td height=21 width=75><b><font face=Arial size=2>Option 7:</font></b></td> <td height=21 width=409><font face=Arial size=2>Add additional magazines to your package</font></td> </tr> <tr> <td height=40 width=75><b><font face=Arial size=2>Option 8:</font></b></td> <td height=40 width=409><font face=Arial size=2>Add a hard cover carrying case to protect your marker. This is an excellent storage case. </font><a target=_new href=http://www.tpg.com/paintball/os/rap4-paintball-marker-p-4330.htm><font face=Arial size=2 color=#0000ff>View the case here</font></a></td> </tr> <tr> <td height=21 width=75><b><font face=Arial size=2>Option 9:</font></b></td> <td height=21 width=409><font face=Arial size=2>Additional 5oz cylinder to your package</font></td> </tr> </tbody></table></font></p><p> </p><br><b>Package Includes:</b><br>- 1 x T68 M4 Gen6 - Magazine Fed Paintball Gun ( <a href=\t68-paintball-gun-magazine-fed-c-21_143_340.html\> more info</a> ) <br />- 1 x 5 Year Warranty<br />- 1 x <a href=\product_info.php/products_id/1129\>20mm Rail<br /></a> - 1 x <a href=\vertical-grip-black-p-301.html\>RIS Vertical Grip</a><br />- 1 x <a href=\product_info.php/products_id/146\>M4 Scope Base Mount</a><br />- 1 x <a href=\product_info.php/products_id/63\>True Target Point Sight<br /></a> - 1 x <a href=\advanced_search_result.php?keywords=exacto&inc_subcat=1&Search=Search\> Exacto Laser Sight</a>
It will be like this for a full column. What I need is to be able to pull the very first image url from the text into another cell and colum. I then need all the info from the "Package Includes" into another cell and column. Please let me know if you know how to do this.
Thank you
Bookmarks