CSV file merge

$30-250 USD

În desfășurare

Data postării:

peste 11 ani în urmă

$30-250 USD

Plata la predare

I have a series of CSV files each representing a different day (business day – no files for public holidays or Saturday/Sunday). The files are named based on their date and a 3 character prefix eg. CME_20121204.csv. Each file contains 8 pieces of information for each entry. Each entry is specific to a symbol. I would like a tool that allows me to define a symbol and a date range. The tool would then access each CSV file within that date range, locate the symbol and copy the entry to a new CSV file it created. It would then chronologically order the entries and save the file to a designated location. I have attached an example csv file.

Data Processing

Excel

ID-ul proiectului: 4023782

Despre proiect

17 propuneri

Proiect la distanță

Activ: 11 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@developer287

i am the best one to make this script. i will write it in vb.net to merge all your files in one click.

$60 USD în 1 zi

0,0

(0 recenzii)

1,6

17 freelanceri plasează o ofertă medie de $71 USD pentru proiect

@nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to identify the current input and output files, active controls (e.g. for inputting symol, date range), etc. This approach makes further use of the macro very convenient by offering the usual Open file dialog or a Control form containing information necessary to identify the current input and output files. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!

$90 USD în 3 zile

4,9

(40 recenzii)

5,4

@vbexcel

Excel/VBA pro with over ten years of experience.

$80 USD în 1 zi

4,9

(25 recenzii)

5,2

@svteam

Hi, check private message for details. Thanks.

$75 USD în 1 zi

4,9

(25 recenzii)

5,1

@finecodervw

Hi, I went through the description and very much interestd to take this. I have provded more inormation through Private Message box. Would appreciate if we can discuss further on this. Thanks

$200 USD în 7 zile

4,9

(20 recenzii)

4,6

@FLtowhid

Please see my PM.

$70 USD în 4 zile

4,7

(4 recenzii)

3,8

@vikashgadia

we r excel macro expert would like to offer our services.

$50 USD în 1 zi

4,8

(13 recenzii)

3,5

@eried

My proposal is a small application that asks you the location of the CSV files, then you input the symbol and date and click "Export".

$85 USD în 1 zi

5,0

(6 recenzii)

3,3

@adim

Top 1% in VBA on Freelancer and lot of experience in this field, please check PM.

$55 USD în 2 zile

4,9

(5 recenzii)

3,3

@vnb400sl

i can develop an app for this

$50 USD în 3 zile

5,0

(9 recenzii)

3,2

@expertcoder1vw

Hello, I can do this job by developing a custom Windows application to merge the CSV files based on the merging criteria. Can complete in 2 days. Bests, Larry

$40 USD în 2 zile

5,0

(2 recenzii)

3,1

@rohitagarberg

Sir , we have read your requirements of merging the csv sheets and we can complete it as soon as it is given to us. we have 100% completion rate in all our projects. Thanks

$30 USD în 3 zile