Devam Ediyor

491542 CSV parsing/customisation tool

Hi all,

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

1st: orderID

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

11th: sku

12th: qtyOrdered

13th: price

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!

Thanks all

Beceriler: Her şey Kabul, Düzenleme, Web Sitesi Yönetimi

Daha fazlasını görün: names editing, tool to edit files, parsing tool, hh, editing my 12th, folder sit, tool folder, folder tool, excel check double, excel csv quotes, csv create save, excel exe, please check date attached file, price information tool, excel delimited, csv create, forward price excel, create excel csv file, please check excel attachment, sku parsing project, result double, file csv exe, price forward excel, create structure excel, attachment zip

İşveren Hakkında:
( 14 değerlendirme )

Proje NO: #2237453

Seçilen:

eperfections

Simple, easy and straight forward project. I can do this. Regards ePerfections

1 gün içinde 100$ USD
(326 Değerlendirme)
6.9