CSV file joiner
€30-250 EUR
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.
Project ID: #5341754
About the project
Awarded to:
Hi I work for ING as a vba programmer, I can assure you of happy cooperation for poth of us :) s
24 freelancers are bidding on average €105 for this job
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
Hi, I will be happy to help you with this code. Looking forward to your response ---------------------------------------------------------------------------------------------------------------------------
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
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
hey Mbt11, we have completed over 70 excel projects, you can clearly understand the expertise we have, please reply, we can discuss further, thanks !
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
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.
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
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
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.
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