The goal is to search files, which have already been downloaded from a website. These files can be in either .txt or .html format (depending on which is more appropriate, you tell me), samples are attached.
The end result is to extract two pieces of information, name and address, and place these in a .txt file so that they can be imported into excel. This information should only be extracted if the following criteria is met: There must be a positive balance for at least three (3) years. The balance is shown in the total column. If there is a positive balance for three (3) or more years, the name and address need to be extracted to a .txt in the format nameaddress. This way I can use the space delimited function in excel to easily create a list.
The files attached are named exactly as they will be and the program must be capable of searching through 20,000 records or more.
I suppose a visual basic type program used as an excel macro may work or possibly reading the .txt files. Unfortuneately the .txt files do not have any formatting, so all of the data is connected.
Please email me for more information or with any questions. I am somewhat of a novice at this. I recognize that this can be done and that for someone very knowledgable it should be somewhat simple, but I may have done a poor job of explaining! Thanks.