I have the following csv file with 2 lines but it could contain many lines of information being the first line alway the same header
and then each consecutive line has purchase order details:
file1.csv
Line 1 SalesOrderNumber,LineItem,OrderNumber,Description,PartNumber,Revision,UnitOfMeasure,Location,OrderType,InventoryPlanning,PlannerCode,OrderDate,RequestDate,PromiseDate,Quantity,RecommendedOrderQty,Priority,Expedite,Vendor,VendorId,UnitCost,ExtendedCost,VarianceCost,Customer,Source,Notes,VarianceNotes,UDF1,UDF2,UDF3,UDF4,UDF5,UDF6,UDF7,UDF8,PercOfBuffer,Profile,PartType,MaterialType,Order,Variance,StartDate,Late,Status,OrderId,DueDate,LinkCode,CreatedByUser
Line 2 actual data like described on line 1
Line 3 actual data like described on line 1
Line n actual data like described on line 1
I need to read this CSV delete the header on line 1 and leave it like this with the data:
file2.csv
Line 1 Location,,OrderDate,PlannerCode,PartNumber,,Location,UnitOfMeasure,Quantity,PromiseDate
.... repeat for as many lines as there are after line 2, then save the file as csv on a directory and delete file1.csv
The OrderDate and PromiseDate are on file.csv on the format 10/30/2017 but on file2.csv they need to be 20171030
Please help, thank you.
