Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cleaning up a web query
I'm bringing in some tables from a web page. The cell contents I want
to keep are those that have text that is hyperlinked. There are other cells that are a hyperlink only (no text) or text only that I want to clear. What approach should I take? I'm thinking I can loop through the range, but I'm never worked with this type of data and don't know how to specify the conditions for clearing the unwanted cells. TIA, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cleaning up a web query
What is often done is to just use a macro or formulas to get what you need
from the sheet where the web page was brought in to the sheet where it is needed. More info and a url might be helpful. -- Don Guillett SalesAid Software "Jim" wrote in message oups.com... I'm bringing in some tables from a web page. The cell contents I want to keep are those that have text that is hyperlinked. There are other cells that are a hyperlink only (no text) or text only that I want to clear. What approach should I take? I'm thinking I can loop through the range, but I'm never worked with this type of data and don't know how to specify the conditions for clearing the unwanted cells. TIA, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cleaning up a web query
A typical page I'm pulling in is
http://www.llbean.com/webapp/wcs/sto...d=-1&feat=dp26. From this, I pull in tables 11,12,13,14 with full HTML formatting. The only cells I'm interested in keeping the contents of are the text hyperlink cells. I use a custom function to extract the URL from the hyperlink into a cell above it, from which I use a MID function to get a product ID into a cell above it also that I can then do vlookups off of to pull in the data I want displayed. But you'll notice that there is a cell where the webpage image is that just holds a hyperlink, as well as the price text, that I'd like cleared. I've noticed in pulling in different pages that these aren't always on the same row, so I can't do a shortcut that way. Thanks again, Jim Don Guillett wrote: What is often done is to just use a macro or formulas to get what you need from the sheet where the web page was brought in to the sheet where it is needed. More info and a url might be helpful. -- Don Guillett SalesAid Software "Jim" wrote in message oups.com... I'm bringing in some tables from a web page. The cell contents I want to keep are those that have text that is hyperlinked. There are other cells that are a hyperlink only (no text) or text only that I want to clear. What approach should I take? I'm thinking I can loop through the range, but I'm never worked with this type of data and don't know how to specify the conditions for clearing the unwanted cells. TIA, Jim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cleaning up a web query
If you want to send me the workbook with a description(BY CELL ADDRESS) what
you want, I will take a look. -- Don Guillett SalesAid Software "Jim" wrote in message ups.com... A typical page I'm pulling in is http://www.llbean.com/webapp/wcs/sto...d=-1&feat=dp26. From this, I pull in tables 11,12,13,14 with full HTML formatting. The only cells I'm interested in keeping the contents of are the text hyperlink cells. I use a custom function to extract the URL from the hyperlink into a cell above it, from which I use a MID function to get a product ID into a cell above it also that I can then do vlookups off of to pull in the data I want displayed. But you'll notice that there is a cell where the webpage image is that just holds a hyperlink, as well as the price text, that I'd like cleared. I've noticed in pulling in different pages that these aren't always on the same row, so I can't do a shortcut that way. Thanks again, Jim Don Guillett wrote: What is often done is to just use a macro or formulas to get what you need from the sheet where the web page was brought in to the sheet where it is needed. More info and a url might be helpful. -- Don Guillett SalesAid Software "Jim" wrote in message oups.com... I'm bringing in some tables from a web page. The cell contents I want to keep are those that have text that is hyperlinked. There are other cells that are a hyperlink only (no text) or text only that I want to clear. What approach should I take? I'm thinking I can loop through the range, but I'm never worked with this type of data and don't know how to specify the conditions for clearing the unwanted cells. TIA, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Cleaning | Excel Discussion (Misc queries) | |||
Cleaning up some VB | Excel Programming | |||
Cleaning Sheets | Excel Programming | |||
Help cleaning up some Strings | Excel Programming | |||
cleaning up a field | Excel Programming |