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.
Hi Adam
Just to make things clear.
Each one of your files contain Lines of format
<<>>
(ie amounts seperated by $signs), process file only if you find >=3 positive amounts in this line.
If >=3 numbers found then extract name & address from the lines
<<>>
If this is your exact requiremnent and all files are of same format then I can do it using
Visual Basic
Visual Basic .NET
VBA (Excel)
Other scripting langs like PHP
If it a purely one off excercise - then you wouldnt be too worried about the GUI quality etc.
In any cas we can sort this problem out foe you pretty quickly
thanks
John
Hello,
I have placed a bid on the higher side and more days because I know that these type of jobs can throw up some unexpected results while working. I have good experience in doing this type of work i.e. ripping apart HTML files and my last sucessful project from this website has been on similar lines.
The data can be directly put into excel files or in any other type of file/database that you desire.
Sir,
I have experience in accomplishing this kind of projects in our company which I am working right now. If you want I can also provide the result in excel sheet also along with formatting.
I will show you the job, then you pay me.
Siddharth.
Hi
We can make it in Visual Basic in such a way that the prg will take html files froma directory and place the txt files with criteria based output ina different directory. If u have downloaded these files from a website, u can tell us the site , so that our prg can automatically check for updations also.
If u need this as an additional facility, we are capable of doing it with autorun facility to run at a specified time everyday.
Please call us for further disussions.
Venkat
I understand your scope of work: A program and steps that can be used to extract data from a html file, subject to meeting certain criteria (if possible, the program can process the html file directly, instead of converting it to txt file first). Prior to purchase, I can do a free mock-up showing the output for you. This will give you an idea of the quality involved. The project will take approximately 5 days.
Sir,
We can do this with html files more easily and perfectly. If you need we can make an excel file or a comma or tab delimited file as space delimited may cause errors while importing to excel as names and addresses also contain spaces.
To provide the source code and executable for an easy to use (and reuse) data extraction program following your requirements. Using VB6 (windows) input from txt, output to txt. Treat all txt files found in a certain directory, create an output directory and txt files.
Hi, I have a lot of expertise, and already have developed many tools like this. High GUI and quality, wizard mode, log files match and those that not; easy use. Choose me today and begin tomorrow to work with your list..