Hello coders, I need a program which will edit a CSV excel file as per specifications below. The program will store the location where it picks the CSV file for editing and the program will also store the location where it generates the edited output file as well as edited output file name. The CSV file which needs to be edited will look like as shown in the attached sample file "input" and the CSV file after editing will look like as shown in the attached sample file "output". Note that the CSV file may contain hundreds of records so the program should be fast enough to process the file quickly and efficiently. Once the program has picked the CSV file for editing, it will do the following steps to edit the file: 1) Cut column C and insert it into column A 2) Cut column L and insert it into column C 3) Cut column L and insert it into column D 4) Cut column M and insert it into column E 5) Cut column N and insert it into column F 6) Cut column O and insert it into column G 7) Cut column P and insert it into column H 8) Cut column Q and insert it into column I 9) Cut column S and insert it into column J 10) Cut column S and insert it into column K 11) Cut column P and insert it into column L 12) Cut column S and insert it into column O 13) Copy column R and insert it into column S and column T 14) Remove everything before sku= in column N 15) Copy column N and paste it into column U 16) In column C if the value is USPSMedia then change it to Media Mail 17) In column C if the value is USPSExpressMail then change it to Priority Mail 18) In column D enter this value 10/20/2005 13:55 19) Remove the header 20) Save the output file as described above. Please provide me a sample program as per specifications above so I can award you the project immediately. Thank you.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).