Encerrado

Data Extraction

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.

Habilidades: Programação C, Processamento de Dados, Processamento de dados, Visual Basic, Área de trabalho do Windows

Ver mais: novice to, data 0, data extraction balance, poor, pieces, met, list data, job visual basic, goal, format create space, email searching, email reading job, data visual, data searching, data n, data formatting, data format, data an, create data, connected, c data, balance job, file email extract, depending, create balance

Acerca do Empregador:
( 0 comentários ) Woodmere, United States

ID do Projeto: #13566

23 freelancers estão ofertando em média $67 para este trabalho

NishantBamb

i m working with vb and specially vba programming in excell from last 3 yrs. so i think i would definately complete ur job.

$20 USD in 3 dias
(152 Comentários)
7.0
GuruDeveloper

piece of cake. can do it in perl.

$100 USD in 5 dias
(14 Comentários)
5.1
ELTECH

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 Mais

$20 USD in 2 dias
(7 Comentários)
3.2
vibhub

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 Mais

$100 USD in 15 dias
(3 Comentários)
2.3
sureshgarre

can be done

$30 USD em 1 dia
(1 Comentário)
0.6
cireh

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 Mais

$85 USD em 1 dia
(0 Comentários)
0.0
andraeoid

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 Mais

$100 USD in 5 dias
(0 Comentários)
0.0
projcs2004

We are a group of proffesionals having more than 5 yrs experience.We can do the work for you.

$80 USD in 4 dias
(0 Comentários)
4.7
narayana7

Sir I am very much intrested in taking up your work. Please consider me

$78 USD in 15 dias
(0 Comentários)
0.0
manivelank

I'am an experienced freelancer and I have done complex projects in excel and I can do your project as you expect. Thanks

$95 USD in 15 dias
(0 Comentários)
0.0
sahyadriit

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 Mais

$50 USD in 10 dias
(0 Comentários)
0.0
deepakfreelancer

Hey, I think this is very easy task for me .Well give me a chance and i can show u my Talent.VB 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 Mais

$20 USD in 5 dias
(0 Comentários)
0.0
tvkrishnam

I can extract any important data to a database from txt file through VB application

$100 USD in 5 dias
(0 Comentários)
0.0
speedyservice

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 Mais

$100 USD in 5 dias
(0 Comentários)
0.0
superbrain

I can do this project for you.

$50 USD in 5 dias
(0 Comentários)
0.0
raathisoft

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 Mais

$50 USD in 5 dias
(0 Comentários)
0.0
Delon

check PMB for Details

$100 USD in 10 dias
(0 Comentários)
0.0
bid3

we could do it.

$100 USD in 5 dias
(0 Comentários)
0.0
theaddergroup

please see pmb

$50 USD in 2 dias
(0 Comentários)
0.0
mpekv

I can try to do this. I have experiences about this things.

$20 USD in 5 dias
(0 Comentários)
0.0