Suljettu

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.

Taidot: C-ohjelmointi, tiedonsyöttö, tietojenkäsittely, Visual Basic, Windows Desktop

Näytä lisää: novice to, novice novice, data 0, data extraction balance, poor, pieces, met, list data, job visual basic, goal, format for create space, email searching, email reading job, data-extraction, data, data website, data visual, data searching, data n, data formatting, data format, data an, create data, connected, c data

Tietoa työnantajasta:
( 0 arvostelua ) Woodmere, United States

Projektin tunnus: #13566

23 freelancers are bidding on average $67 for this job

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 3 päivässä
(152 arvostelua)
7.0
GuruDeveloper

piece of cake. can do it in perl.

100 $ USD 5 päivässä
(14 arvostelua)
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 Lisää

20 $ USD 2 päivässä
(7 arvostelua)
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 Lisää

100 $ USD 15 päivässä
(3 arvostelua)
2.3
sureshgarre

can be done

30 $ USD 1 päivässä
(1 arvostelu)
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 Lisää

85 $ USD 1 päivässä
(0 arvostelua)
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 Lisää

100 $ USD 5 päivässä
(0 arvostelua)
0.0
projcs2004

We are a group of proffesionals having more than 5 yrs [url removed, login to view] can do the work for you.

80 $ USD 4 päivässä
(0 arvostelua)
4.7
narayana7

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

78 $ USD 15 päivässä
(0 arvostelua)
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 15 päivässä
(0 arvostelua)
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 Lisää

50 $ USD 10 päivässä
(0 arvostelua)
0.0
deepakfreelancer

Hey, I think this is very easy task for me .Well give me a chance and i can show u my [url removed, login to view] 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 Lisää

20 $ USD 5 päivässä
(0 arvostelua)
0.0
tvkrishnam

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

100 $ USD 5 päivässä
(0 arvostelua)
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 Lisää

100 $ USD 5 päivässä
(0 arvostelua)
0.0
superbrain

I can do this project for you.

50 $ USD 5 päivässä
(0 arvostelua)
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 Lisää

50 $ USD 5 päivässä
(0 arvostelua)
0.0
Delon

check PMB for Details

100 $ USD 10 päivässä
(0 arvostelua)
0.0
bid3

we could do it.

100 $ USD 5 päivässä
(0 arvostelua)
0.0
theaddergroup

please see pmb

50 $ USD 2 päivässä
(0 arvostelua)
0.0
mpekv

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

20 $ USD 5 päivässä
(0 arvostelua)
0.0