How Do I extract specific data from one cell to another?

**tpg45** · 04-18-2009, 04:20 PM

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

<img height=351 width=500 border=0 src=http://www.tpg.com/paintball/images/T68/T68_True_Target_Marker_LF.jpg /> <img height=371 width=500 border=0 src=http://www.tpg.com/paintball/images/T68/T68_True_Target_Marker_LB.jpg /> <table width=500 cellspacing=0 cellpadding=0 border=0 id=table1> <tbody> <tr> <td>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..</td> </tr> </tbody></table> Available Options<table height=293 id=table2> <tbody> <tr> <td height=9 width=75 valign=center>Option 1:</td> <td height=9 width=409>There are 9 different air options to choose from: <a target=_new href=http://www.tpg.com/paintball/t68_air_system.html>View the different air system available here</a></td> </tr> <tr> <td height=12 width=75 valign=center>Option 2:</td> <td height=12 width=409>Your marker comes with a 14" Tactical barrel, you can upgrade your barrel to rifled version for better performance. You can <a target=_new href=http://www.tpg.com/paintball/os/barrel-systems-tactical-rifled-barrel-c-22_220_388.html>view the different barrels and specs here</a></td> </tr> <tr> <td height=40 width=75 valign=center>Option 3:</td> <td height=40 width=409>With this 200 rounds hopper adaptor and you can change out your magazine fed marker to use a hopper</td> </tr> <tr> <td height=11 width=75>Option 4:</td> <td height=11 width=409>This kit comes with all the o-rings to completely rebuilt your marker</td> </tr> <tr> <td height=2 width=75>Option 5:</td> <td height=2 width=409>This tool kit has all the tools for you to service your marker</td> </tr> <tr> <td height=21 width=75>Option 6:</td> <td height=21 width=409>Extend your manufacture warranty to 3 years</td> </tr> <tr> <td height=21 width=75>Option 7:</td> <td height=21 width=409>Add additional magazines to your package</td> </tr> <tr> <td height=40 width=75>Option 8:</td> <td height=40 width=409>Add a hard cover carrying case to protect your marker. This is an excellent storage case. <a target=_new href=http://www.tpg.com/paintball/os/rap4-paintball-marker-p-4330.htm>View the case here</a></td> </tr> <tr> <td height=21 width=75>Option 9:</td> <td height=21 width=409>Additional 5oz cylinder to your package</td> </tr> </tbody></table>  Package Includes: - 1 x T68 M4 Gen6 - Magazine Fed Paintball Gun ( <a href=\t68-paintball-gun-magazine-fed-c-21_143_340.html\> more info</a> ) - 1 x 5 Year Warranty - 1 x <a href=\product_info.php/products_id/1129\>20mm Rail </a> - 1 x <a href=\vertical-grip-black-p-301.html\>RIS Vertical Grip</a> - 1 x <a href=\product_info.php/products_id/146\>M4 Scope Base Mount</a> - 1 x <a href=\product_info.php/products_id/63\>True Target Point Sight </a> - 1 x <a href=\advanced_search_result.php?keywords=exacto&inc_subcat=1&Search=Search\> Exacto Laser Sight</a>

End of Cell data
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

**shg** · 04-18-2009, 04:42 PM

A workbook with a before and after example, please?

**tpg45** · 04-18-2009, 05:00 PM

Here is the file format I'd need

**shg** · 04-18-2009, 06:54 PM

This works for the example, but I expect others would break it.

**tpg45** · 04-18-2009, 08:54 PM

So far this is looking great. Only question is what do I have to do to make this work in a new xls file? I tried using the formula you gave in a new excel file but kept getting this #NAME? Is there something else I have to set up in a new file for this? Also, I get the same thing when copying the cell over into another excel file. What I need to do after this is done is take the columns Images & Product Packages and place the extracted information into another excel file template so the data uploads properly into my ecommerce store. How do I copy this information properly?
Thanks again, really appreciate it.

**tpg45** · 04-18-2009, 09:02 PM

Hey, also noticed with the image cell on this descriptions it pulled some sort of ad from the desription?

 <table width=500 cellspacing=0 cellpadding=0 border=0 id=table2> <tbody> <tr> <td>This package is designed for special recon operations. Armed with high mount red dot sight for fast target acquisition to take out fast moving targets. </td> </tr> </tbody></table> <img height=362 width=500 border=0 src=http://www.rap4.com/paintball/images/T68/T68_Paintball_Gun_Recon_1_FL.jpg /> <img height=211 width=500 border=0 src=http://www.rap4.com/paintball/images/T68/T68_Paintball_Gun_Recon_1_L.jpg /><script language='JavaScript' type='text/javascript' src='http://www.rap4.com/ads/adx.js'></script> <script language='JavaScript' type='text/javascript'></script><noscript><a href='http://www.rap4.com/ads/adclick.php?n=a0824a10' target='self'><img src='http://www.rap4.com/ads/adview.php?what=zone:21&n=a0824a10' border='0' alt=''></a></noscript> Key features: - .68 caliber system—uses all standard paintballs! - Semi-automatic (optional upgrade for semi/burst/auto) - Internal Flexi-Air system - All-metal body - Weaver flattop rail - ASTS trigger - Works with CO2/Compressed Air/HPA/Nitrogen tanks of all sizes - Maximum range: 300 feet - Effective range: 150 feet - Velocity 200-325 fps (adjustable)   Available Options<table height=293 id=table3> <tbody> <tr> <td height=9 width=75 valign=center>Option 1:</td> <td height=9 width=409>There are 9 different air options to choose from: <a target=_new href=http://www.rap4.com/paintball/t68_air_system.html>View the different air system available here</a></td> </tr> <tr> <td height=12 width=75 valign=center>Option 2:</td> <td height=12 width=409>Your marker comes with a 10" barrel, you can upgrade your barrel to rifled version for better performance. You can <a target=_new href=http://www.rap4.com/paintball/os/barrel-systems-tactical-rifled-barrel-c-22_220_388.html>view the different barrels and specs here</a></td> </tr> <tr> <td height=40 width=75 valign=center>Option 3:</td> <td height=40 width=409>With this 200 rounds hopper adaptor and you can change out your magazine fed marker to use a hopper</td> </tr> <tr> <td height=11 width=75>Option 4:</td> <td height=11 width=409>This kit comes with all the o-rings to completely rebuilt your marker</td> </tr> <tr> <td height=2 width=75>Option 5:</td> <td height=2 width=409>This tool kit has all the tools for you to service your marker</td> </tr> <tr> <td height=21 width=75>Option 6:</td> <td height=21 width=409>Extend your manufacture warranty to 3 years</td> </tr> <tr> <td height=21 width=75>Option 7:</td> <td height=21 width=409>Add additional magazines to your package</td> </tr> <tr> <td height=40 width=75>Option 8:</td> <td height=40 width=409>Add a hard cover carrying case to protect your marker. This is an excellent storage case. <a target=_new href=http://www.rap4.com/paintball/os/rap4-paintball-marker-p-4330.htm>View the case here</a></td> </tr> <tr> <td height=21 width=75>Option 9:</td> <td height=21 width=409>Additional 5oz cylinder to your package</td> </tr> </tbody></table>   Package Includes: - 1 x T68 M4 Gen6 - Magazine Fed Paintball Gun ( <a href=\t68-paintball-gun-magazine-fed-c-21_143_340.html\> more info</a> ) - 1 x 5 Year Warranty - 1 x 10 Inch Recon Barrel - 1 x Phantom Handguard - 1 x Gemtech Silencer ( <a href=\gemtech-threadon-silencer-double-threaded-rifled-barrel-p-3754.html\> more info</a> ) - 1 x Scope Mount Base ( <a href=\paintball-m16m4-scope-mount-base-p-6051.html\>more info</a> ) - 1 x Red Dot 1x40mm Scope ( <a href=\tippmann-krinkov-40mm-scope-p-3705.html\>more info</a> )

Thanks again man

**tpg45** · 04-18-2009, 09:05 PM

Sorry to keep bothering you but you've helped me out already so much, can you tell me how to do this? If a product description doesn't have a "Packages Includes" then how do I pull the description text from it? Here's an example, it's for a barrel.

 <IMG height=320 src=http://www.rap4.com/images/barrel/22_Inch_Sniper_Barrel.jpg width=500 border=0> <IMG height=285 src=http://www.rap4.com/images/barrel/Tippmann_X7_22_Inch_Sniper_Barrel_Gun.jpg width=500 border=0> <TABLE id=table2 width=500 border=0><TBODY><TR><TD>NEW .68 Caliber Tippmann X7 22 Inch Super Sniper Barrel. The high quality of these rifled barrels will give you supreme performance on the field! This new 22 Inch Super Sniper Barrel is designed for scenario paintball markers such as those from Tippmann, BT Paintball, and our Real Action Paintball T68! These barrels are designed to accept a handguard, front sight, rail system and even grenade launchers! These new Tactical Rifled Barrels are designed on the outside for looks and engineered on the inside to greatly improve accuracy and reliability. Available in 12, 14, 16, 18 and 22. The Tippmann X7 22 Inch Super Sniper Barrel is key to converting a paintball marker for scenario play. It can be used as an attachment point for all manner of accessories, as the Tactical Rifled Barrel is scaled from military specs and takes most attachments without anything modifications. This barrel can accommodate rails, mounts, laser sights and grenade launchers without making any changes to the marker or the barrel. This Tippmann X7 22 Inch Super Sniper Barrel will not just make your marker look and feel better, but will also enhance your accuracy as well! <TABLE id=table4 width=400 border=0><TBODY><TR><TD width=34><A href=http://www.rap4.com/paintball/os/barrel-systems-tactical-rifled-barrel-c-22_220_388.html><IMG height=30 src=http://www.rap4.com/images/info_arrow.gif width=30 border=0></A></TD><TD><A href=http://www.rap4.com/paintball/os/barrel-systems-tactical-rifled-barrel-c-22_220_388.html>More information and specification</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG height=353 src=http://www.rap4.com/images/barrel/Tippmann_98_22_Inch_Sniper_Barrel_Gun.jpg width=500 border=0> <IMG height=309 src=http://www.rap4.com/images/barrel/Spyder_22_Inch_Sniper_Barrel_Gun.jpg width=504 border=0> <IMG height=314 src=http://www.rap4.com/images/barrel/Viewloader_22_Inch_Sniper_Barrel_Gun.jpg width=500 border=0> <IMG height=336 src=http://www.rap4.com/images/barrel/Tippmann_A5_22_Inch_Sniper_Barrel_Gun.jpg width=525 border=0> <IMG height=307 src=http://www.rap4.com/images/T68_Gen5/T68_Gen5_TS_Side.jpg width=500 border=0>

**shg** · 04-18-2009, 10:48 PM

f a product description doesn't have a "Packages Includes" then how do I pull the description text from it?

I don't have a clue; if they're all different, there has to some definitive aspect.

You look at your examples and tell me.

**tpg45** · 04-19-2009, 12:25 PM

Hello,
Is there a formula that if the description doesn't include the "Packages" Section to then pull the plain text description from the cell? Eg In the above html description there is no Packages section so is it possible to then have the formula automatically pull the plain text below from it?

"NEW .68 Caliber Tippmann X7 22 Inch Super Sniper Barrel. The high quality of these rifled barrels will give you supreme performance on the field! This new 22 Inch Super Sniper Barrel is designed for scenario paintball markers such as those from Tippmann, BT Paintball, and our Real Action Paintball T68! These barrels are designed to accept a handguard, front sight, rail system and even grenade launchers! These new Tactical Rifled Barrels are designed on the outside for looks and engineered on the inside to greatly improve accuracy and reliability. Available in 12, 14, 16, 18 and 22. The Tippmann X7 22 Inch Super Sniper Barrel is key to converting a paintball marker for scenario play. It can be used as an attachment point for all manner of accessories, as the Tactical Rifled Barrel is scaled from military specs and takes most attachments without anything modifications. This barrel can accommodate rails, mounts, laser sights and grenade launchers without making any changes to the marker or the barrel. This Tippmann X7 22 Inch Super Sniper Barrel will not just make your marker look and feel better, but will also enhance your accuracy as well!

Thanks again