CSV file joiner

Ολοκληρωμένο Αναρτήθηκε Jan 20, 2014 Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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 για Εφαρμογές

Ταυτότητα Εργασίας: #5341754

Σχετικά με την εργασία

24 προτάσεις Απομακρυσμένη εργασία Ενεργό Jan 21, 2014

Ανατέθηκε στον:

mateuszsawka

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

€50 EUR σε 1 μέρα
(2 Αξιολογήσεις)
3.0

24 freelancers κάνουν προσφορές κατά μέσο όρο €105 για αυτή τη δουλειά

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 Περισσότερα

€100 EUR σε 2 μέρες
(200 Αξιολογήσεις)
7.3
zExcel

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

€100 EUR σε 1 μέρα
(252 Αξιολογήσεις)
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 Περισσότερα

€90 EUR σε 1 μέρα
(71 Αξιολογήσεις)
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 Περισσότερα

€50 EUR σε 3 μέρες
(60 Αξιολογήσεις)
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 σε 1 μέρα
(97 Αξιολογήσεις)
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 Περισσότερα

€111 EUR σε 6 μέρες
(115 Αξιολογήσεις)
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 σε 0 μέρες
(149 Αξιολογήσεις)
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 σε 3 μέρες
(15 Αξιολογήσεις)
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 σε 1 μέρα
(31 Αξιολογήσεις)
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 Περισσότερα

€111 EUR σε 1 μέρα
(14 Αξιολογήσεις)
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 Περισσότερα

€98 EUR σε 3 μέρες
(9 Αξιολογήσεις)
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 Περισσότερα

€60 EUR σε 1 μέρα
(22 Αξιολογήσεις)
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 Περισσότερα

€111 EUR σε 3 μέρες
(11 Αξιολογήσεις)
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 Περισσότερα

€155 EUR σε 1 μέρα
(2 Αξιολογήσεις)
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 Περισσότερα

€40 EUR σε 2 μέρες
(1 Κριτική)
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. Περισσότερα

€80 EUR σε 5 μέρες
(1 Κριτική)
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, Περισσότερα

€277 EUR σε 3 μέρες
(2 Αξιολογήσεις)
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 σε 3 μέρες
(0 Αξιολογήσεις)
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 Περισσότερα

€66 EUR σε 3 μέρες
(0 Αξιολογήσεις)
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 σε 7 μέρες
(0 Αξιολογήσεις)
0.0