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.
23 freelance font une offre moyenne de $67 pour ce travail
i m working with vb and specially vba programming in excell from last 3 yrs. so i think i would definately complete ur job.
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 Plus
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 apa Plus
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 lis Plus
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 di Plus
We are a group of proffesionals having more than 5 yrs [login to view URL] can do the work for you.
I'am an experienced freelancer and I have done complex projects in excel and I can do your project as you expect. Thanks
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 Plus
Hey, I think this is very easy task for me .Well give me a chance and i can show u my [login to view URL] should be very good for this project and i m expertise in VB Text file will be very good option .VB can read text f Plus
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 conve Plus
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 web Plus