Ok ... I'd like to see if someone can build an application, script, macro, or something (I don't know) that will allow me to enter in a particular search term (let's say "office") and have the app (or whatever) go to the following url:
[login to view URL];startnumber=0
*"office" is the replaceable search term.
*the "startnumber" begins at 0, then goes to 50, 100, 150, etc until it reaches the last entry in the search.
The idea is for me to be able to put in any search term I need and have the app/script scan through all of the results from the site to find the specific entries that fulfill my given parameters ... and extract the information from the five colums presented (including the hyperlinked coproration name) and export it to an Excel spreadsheet or other Microsoft application.
As an example, let's say that I want to find all the corporation names that have the term "office" in it, a status of "suspended", the year of the date filed as "2004", and no more than 20 characters in the corporation name.
*For searching purposes, I would like the option of changing the search term, the status, the year filed, and the number of characters in the corporation name.
Does that make sense? If not, please pm for clarification.
Hello, I already have my own java based scraping/extracting software which is shown its strength in several projects. It just need to be finetuned for your task. thank you,
pacejob
Hi, man. I've done such feature recently for my purposes. So about your task - it will be very simple app which will go to site that you will define an using HTTPWebRequest will read data from page with startnumber from 0 to the end. Then It will convert results to beautiful grid so you will be free to do anything with it )