I just want a small exe tool created that will modify one or more CSVs in one folder into a single CSV of different formatting in another folder. I have strict requirements for these so please check the attachment to follow my explanation. *Note: if viewing CSVs in Excel do not save as it changes the formatting.
I want the tool to sit outside 2 folders (as attached in zip file)
/01_csv_toedit/ - CSV file(s) to edit go here (varying names)
/02_csv_result/ - CSV result file to go here named [url removed, login to view]
/exe tool sits here
I have a sample "toedit" file and "result" file in the appropriate folders. I want the "result" file to be EXACTLY as this one.
What the tool should do is take the following information from the "toedit" file(s):
orderId, purchaseDate, sku, qtyOrdered, price
...and create a new file called ProductSalesList.csv. This will need to be edited as following:
-Comma delimited with double quotes for all
2nd: date stamp reformatted as in the sample result file: YYYY/MM/DD HH:MM
3rd: empty but still with quotes
4th: empty but still with quotes
5th: empty but still with quotes
6th: empty but still with quotes
7th: empty but still with quotes
8th: empty but still with quotes
9th: empty but still with quotes
10th: empty but still with quotes
Check the folder structure and sample files for assistance. Also, if more than one file is in the "to edit" folder it'll handle them all and still create the one result file as explained above.
Should be a straight forward project. Hopefully somebody can do this in a few hours!