CSV file merge

$30-250 USD

Igangværende

Slået op

over 11 år siden

$30-250 USD

Betales ved levering

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

Projekt-ID: 4023782

Om projektet

17 forslag

Projekt på afstand

Aktiv 11 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@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 på 1 dag

0,0

(0 anmeldelser)

1,6

17 freelancere byder i gennemsnit $71 USD på dette job

@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 på 3 dage

4,9

(40 anmeldelser)

5,4

@vbexcel

Excel/VBA pro with over ten years of experience.

$80 USD på 1 dag

4,9

(25 anmeldelser)

5,2

@svteam

Hi, check private message for details. Thanks.

$75 USD på 1 dag

4,9

(25 anmeldelser)

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 på 7 dage

4,9

(20 anmeldelser)

4,6

@FLtowhid

Please see my PM.

$70 USD på 4 dage

4,7

(4 anmeldelser)

3,8

@vikashgadia

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

$50 USD på 1 dag

4,8

(13 anmeldelser)

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 på 1 dag

5,0

(6 anmeldelser)

3,3

@adim

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

$55 USD på 2 dage

4,9

(5 anmeldelser)

3,3

@vnb400sl

i can develop an app for this

$50 USD på 3 dage

5,0

(9 anmeldelser)

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 på 2 dage

5,0

(2 anmeldelser)

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 på 3 dage