We look for a programmer who writes a script for us that is - when called up - auto creating 2 new csv files from 2 original csv files. The new csv shall contain an additional column created out of the information of the original file. Be aware of German special charackters correctly interpreted as well as different column separators and partly different column headlines. Leading zeros must also be kept in new file. Source and Target folder of the files shall be identical as Z:\Rezeptanforderungen\vtiger. We will provide the original csv files for applicants. Please offer an already readymade script for our testing with limited sample lines (for your safety).
Sample:
Name of original file 1: [login to view URL]
Name of new file 1: [login to view URL]
headlines of original file 1:
W2D Aerzte ID,Salutation,Title,Name,Vorname,Billing Address,Billing Code,Billing City,Phone,Other Phone,Fax,Email,Website,Description,industry,Assigned To,Account Name
sample data line of original file 1:
911,Frau,Dr.,Aalburg,Melanie,Berliner Allee 105,13088,Berlin,(030)49857840,,(030)498578429,,,ALG,Arztpraxis,Team Selling,Aalburg Melanie (Dr.)
headlines of new file 1:
W2D Aerzte ID,Salutation,Title,Name,Vorname,Billing Address,Billing Code,Billing City,Phone,Other Phone,Fax,Email,Website,Description,industry,Assigned To,Account Name, Secondary Email
sample data of new file 1:
911,Frau,Dr.,Aalburg,Melanie,Berliner Allee 105,13088,Berlin,(030)49857840,,(030)498578429,,,ALG,Arztpraxis,Team Selling,Aalburg Melanie (Dr.), (030)498578429@[login to view URL]
Name of original file 2: [login to view URL]
Name of new file 2: [login to view URL]
headlines of original file 2:
Oberkundennummer; Organisation; Rechnungsadresse Straße; Rechnungsadresse PLZ; Rechnungsadresse Ort; Fax; zuständig
sample data line of original file 2:
00002;Seniorenzentrum Köp I 1;Werlseestr. 37-39a;12587;Berlin;(030)64428101;Team Selling
headlines of new file 2:
Oberkundennummer; Organisation; Rechnungsadresse; Rechnungsadresse PLZ; Rechnungsadresse Ort; Fax; zuständig; andere E-Mail
sample data of new file 2:
00002;Seniorenzentrum Köp I 1;Werlseestr. 37-39a;12587;Berlin;(030)64428101;Team Selling; (030)64428101@[login to view URL]