Find Jobs
Hire Freelancers

CSV file joiner

€30-250 EUR

Terminado
Publicado hace alrededor de 10 años

€30-250 EUR

Pagado a la entrega
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.
ID del proyecto: 5341754

Información sobre el proyecto

24 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi I work for ING as a vba programmer, I can assure you of happy cooperation for poth of us :) s
€50 EUR en 1 día
5,0 (2 comentarios)
3,0
3,0
24 freelancers están ofertando un promedio de €105 EUR por este trabajo
Avatar del usuario
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 full satisfaction. I am also open to modifications to the scope of project. My solution is Excel VBA based. Looking forward to working with you. Regards, Arul
€100 EUR en 2 días
5,0 (200 comentarios)
7,3
7,3
Avatar del usuario
Hi, I will be happy to help you with this code. Looking forward to your response ---------------------------------------------------------------------------------------------------------------------------
€100 EUR en 1 día
4,9 (252 comentarios)
7,6
7,6
Avatar del usuario
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 second CSV file ? The only difference I see between point no 2) and 3) is of adding file names to row and columns. I am using VBA macro in Excel to achieve this and it is the best way. If you would like to continue with me, I can provide you the solution in a few hours, by tailoring it to your exact requirements. If you have any concerns regarding my bid, kindly discuss. I am keen to take this one up. Regards. Usman.
€90 EUR en 1 día
5,0 (71 comentarios)
6,7
6,7
Avatar del usuario
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 Please provide some csv sample file and I can start to work on this right away. Looking forward for your reply. Regards, Susanto
€50 EUR en 3 días
5,0 (60 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
5,0 (97 comentarios)
6,0
6,0
Avatar del usuario
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 response. Thanks.
€111 EUR en 6 días
4,9 (115 comentarios)
6,2
6,2
Avatar del usuario
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 en 0 día
4,8 (149 comentarios)
5,8
5,8
Avatar del usuario
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 en 3 días
4,9 (15 comentarios)
5,6
5,6
Avatar del usuario
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 en 1 día
4,9 (31 comentarios)
5,6
5,6
Avatar del usuario
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 you would like to discuss this further please feel free to contact me. Thank you, Tom
€111 EUR en 1 día
5,0 (14 comentarios)
4,8
4,8
Avatar del usuario
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, Adrian
€98 EUR en 3 días
4,9 (9 comentarios)
4,1
4,1
Avatar del usuario
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 this. If the output file is also going to be a CSV file, it may be better to use an external program that runs on the command-line and is written in bash (if Linux) or C (Windows or Linux) to easily achieve that same result without having to use Excel at all. The choice is yours. I can build you a script in VBA or C (and be complete within 24 hours) to do the concatenation that you need (at the best rate), and I am available to start right now. Best regards, Brent
€60 EUR en 1 día
4,9 (22 comentarios)
3,9
3,9
Avatar del usuario
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 files. Best Regards, Constantin Plaiasu
€111 EUR en 3 días
5,0 (11 comentarios)
3,3
3,3
Avatar del usuario
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 cater to your requirements. My proposal would be to use Excel VBA (since we are working with CSV files, this is the most logical choice). The trick is to point the program at the folder and then cycle through each file, opening and copying the contents to the destination file. The target directory can be entered in a cell with a button next to it to launch the program, allowing you the flexibility to change the directory easily if you wish. The file name parsing is also not a problem, as part of the technique in cycling through files in a directory is retrieving the file name, which can then be parsed to get the sub-string up to the first underscore. Part of my Freelancer ethos is to ensure my clients are 100% happy with my work before moving on. I will NOT dump something into your lap and walk away. I will submit a draft version for your review, take any feedback you may have and iterate the versions until you are completely happy with the finished product. If you would like to discuss your requirements in more detail please let me know.
€155 EUR en 1 día
5,0 (2 comentarios)
2,4
2,4
Avatar del usuario
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 it within 1 day and give you result soon. Can you give me chance to work with it ? If accept my bid, please let's me know, working for you is my happy. Waiting for your reply. Thanks and regards.
€40 EUR en 2 días
4,6 (1 comentario)
2,2
2,2
Avatar del usuario
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. I also completed my M.Sc. Degree. I can use my previous experience to complete your project. I invite you to contact me for further discussion. Hope you will select me. I will be grateful to you if you select me for your project. Thanks.
€80 EUR en 5 días
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
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, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
€277 EUR en 3 días
5,0 (2 comentarios)
1,4
1,4
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 directory first before running it, so I would recommend a VBScript as the solution for 2 reasons. 1) If you have multiple directories it is easier to launch from a batch file or using the for command 2) If you are copying the file in to the directory to just double-click it, the icon will stand out more than an excel icon will over a CSV file (which will also have a different Excel Icon) If you select me, I can produce either method for you as you choose will be best Regards Paul
€66 EUR en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NETHERLANDS
Alphen aan den Rijn, Netherlands
5,0
38
Forma de pago verificada
Miembro desde jun 7, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.