CSV file joiner

Completed Posted Jan 20, 2014 Paid on delivery
Completed Paid on delivery

We need a little script or application developed that

1) joins various CSV data files into one file

2a) adds the filename of each CSV on the first column for each data entry

2b) whilst taking out part of the filename starting with the underscore - e.g. @BLA$[login to view URL] becomes @BLA$BLA

3) creates a second CSV file at the same time, where all filenames are placed in the first row

Imagine a normal use scenario to be one where a user wants to join 500 CSVs in this procedure. All files will be in one folder, and no selection has to take place - if it´s in the folder it has to be part of the procedure.

This script or procedure ideally occurs through some VBA code within Excel, although we are open to suggestions if you believe there is a better solution.

Excel Visual Basic for Apps

Project ID: #5341754

About the project

24 proposals Remote project Active Jan 21, 2014

Awarded to:

mateuszsawka

Hi I work for ING as a vba programmer, I can assure you of happy cooperation for poth of us :) s

€50 EUR in 1 day
(2 Reviews)
3.0

24 freelancers are bidding on average €105 for this job

deepbluetech

Hi mbt11, I have completed some Excel VBA projects where user chooses the folder via the user interface and all the csv files in the folder are processed. Based on my experience, I can complete the project to your More

€100 EUR in 2 days
(200 Reviews)
7.3
zExcel

Hi, I will be happy to help you with this code. Looking forward to your response ---------------------------------------------------------------------------------------------------------------------------

€100 EUR in 1 day
(252 Reviews)
7.6
maverick44000

Hi Mbt. My current project involves merging various CSV files from one folder into a single Excel sheet. I believe you are looking for almost the same functionality. Can you kindly explain point no 3) where you need a More

€90 EUR in 1 day
(71 Reviews)
6.7
sswijaya

Hi, I have done similar project like this, to combine csv files in a folder into one csv file. Please check on this project link: http://www.freelancer.com/projects/Excel/take-several-CSV-files-import.html Pleas More

€50 EUR in 3 days
(60 Reviews)
6.2
gokulanand

Hello, I can get you a VBA script that does this job. I had done these kind of assignments in the past. Let me know if you are interested. Thanks

€55 EUR in 1 day
(97 Reviews)
6.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

€111 EUR in 6 days
(115 Reviews)
6.2
expertatwork

hey Mbt11, we have completed over 70 excel projects, you can clearly understand the expertise we have, please reply, we can discuss further, thanks !

€44 EUR in 0 days
(149 Reviews)
5.8
mhmhz

Hi I can provide you with a desktop application in C# that will do the CSV joining. I am ready to provide any demo to justify my qualifications. Thanks

€250 EUR in 3 days
(15 Reviews)
5.6
pkcyber

I will give u simple application where u can specify the folder where files are , and click on process button. Application will do the processing and give u message of process completed.

€50 EUR in 1 day
(31 Reviews)
5.6
AAATom

Hello! I can do this task within one day. I will need few example CSV files and there are few details that need to be defined but you have defined the task well and there should be no problems finishing it. If More

€111 EUR in 1 day
(14 Reviews)
4.8
adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. I can write the program in VBA. Best regards, Adria More

€98 EUR in 3 days
(9 Reviews)
4.1
Baxter2008

Hello I am an Excel VBA developer. I can quickly and easily set up a VBA macro that loads and joins all the input files into a single-sheet. You are correct that VBA is the quickest and simplest route to achieve More

€60 EUR in 1 day
(22 Reviews)
3.9
cplaiasu

Hello, I can do this using VBA in Excel. If csv files are big (and many) the process will not be very fast. I have experience with VBA. Let me know what version of excel you use and please send me a few test csv More

€111 EUR in 3 days
(11 Reviews)
3.3
tyrmit

Hi, I have completed a number of pieces of work similar to this and believe I would be able to deliver a robust, high-quality solution to you quickly. I already have some code that could be very easily customised to ca More

€155 EUR in 1 day
(2 Reviews)
2.4
NhatAnhIT

Hi mbt11, i have read your requirement and i understand what you want, so i ensure i can do that for you (you can refer to my profile to view same project which i completed before). With this project, i think i will do More

€40 EUR in 2 days
(1 Review)
2.2
AkramHossain8214

I have read your project. I think I am the perfect man to do your project. Though my profile is new, I have worked on similar project in a team(freelancers). I will complete your project as short time as a man can do. More

€80 EUR in 5 days
(1 Review)
1.6
pnjadhav

I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, More

€277 EUR in 3 days
(2 Reviews)
1.4
shehzadwork

I have done similar work on many projects in C# and Java. I can do this work in the form of an application. Consider me for your this project. I will be waiting for your reply and details.

€100 EUR in 3 days
(0 Reviews)
0.0
pfuggles

Hi, I see 2 options for creating this solution 1) Create an Excel file using VBA to perform the merge 2) Create a VBScript to perform the merge Whichever method you use you would need to copy the file in to the dire More

€66 EUR in 3 days
(0 Reviews)
0.0
effedam

Hi, I'm ready to help you to write te code in VBA inside your excel file. It's possible, if you want, write the program in java code. Thank you francesco

€166 EUR in 7 days
(0 Reviews)
0.0