VB Program to split CSV files from multiple lines into single line CSVs
- or -
Post a project like this- Posted:
- Proposals: 7
- Remote
- #1302493
- Awarded
Description
Kind of development: New program from scratch
Description of requirements/functionality: Example:
We have a file like this:
HeaderColum1;Headercolum2;Headercolum3
Sampledata1a;Sampledata2a;Sampledata3a
Sampledata1b;Sampledata2b;Sampledata3b
Turn into this:
HeaderColum1;Headercolum2;Headercolum3
Sampledata1a;Sampledata2a;Sampledata3a
and this:
HeaderColum1;Headercolum2;Headercolum3
Sampledata1b;Sampledata2b;Sampledata3b
Also, the first and second columdata must be part of the new file extension - with "POSTCALCULATION--" before.
POSTCALCULATION--Sampledata1a--Sampledata2a.csv
POSTCALCULATION--Sampledata1b--Sampledata2b.csv
The software must be
- only the sourcecode, we will compile it ourselves (for security reasons)
- no add on DLL must be neccesary
- we will compile it with Visual Studio 2013 ourselves
- it must be very well commented
- must run as a service using SC.exe (http://www.howtogeek.com/50786/using-srvstart-to-run-any-application-as-a-windows-service/)
- must look for the files in a hot folder every 5 mins like C:\Source\sourcefiles.csv then deletes it, after success
- a logfile must be placed in a folder
- must write it to a destination folder: c:\target\POSTCALCULATION--Sampledata1a.csv
- if file already exist, count up like POSTCALCULATION--1_Sampledata1a.csv
- the scourcefile could have lots of rows (like > 10000)
- must run under Win 10 1607 32 and 64bit
OS requirements: Windows
Extra notes:
Steffen M.
100% (33)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Steffen,
Technology Other than VB program will work for you ?
I can do this in C/C++.
Thanks
Sumit
SaS Technologies -
Hi Steffen,
Is the VB program request mandatory? As the task could be achieved with a VBScript run via the Task Scheduler without the need to compile anything. So, would you consider a such solution as well?
Best regards,
Tom -
Hi Steffen,
Can you please invite me ?
I have some questions about your csv files.
Best regards,
FloraSteffen M.27 Sep 2016Hello,
of course. How can I help you?
Best regards,
Steffen MaierFlora May P.27 Sep 2016Hi Steffen,
Can I use your existing csv files as my test data ?
Unfortunately, I'm out of proposal credits. Can you invite to your job post so that I can send a proposal ? :)
Best regards,
Flora -
Do you have a budget for this ?
Steffen M.27 Sep 2016no