
wattsup
Novice
Feb 26, 2016, 8:30 AM
Post #1 of 12
(4422 views)
|
Merge/Append CSV Files together
|
Can't Post
|
|
I have been searching for the best way to merge 2 or more CSV files together. I am very new to perl. Trying to rewrite some old winbatch scripts. First CSV File
BOL,SAP Shipment,Ship From,Ship To,P.O. Number,SAP Transfer,LPN,Material Code,Batch Code,Cases,Weight 81171262,81171262,5026,115075,4500214105,,3000935271,2265536614,5026604900,36,2106.14 81171262,81171262,5026,115075,4500214105,,3000935291,2265536614,5026604900,36,2116.94 81171262,81171262,5026,115075,4500214105,,3000935293,2265536614,5026604900,36,2123.99 81171262,81171262,5026,115075,4500214105,,3000935298,2265536614,5026604900,36,2118.89 Second and so on
BOL,SAP Shipment,Ship From,Ship To,P.O. Number,SAP Transfer,LPN,Material Code,Batch Code,Cases,Weight 81171704,81171704,5026,115076,4500214224,,3000935280,2.2655E+12,5026604900,40,1326.98 81171704,81171704,5026,115076,4500214224,,3000938276,2.2655E+12,5026604800,40,1326.44 81171704,81171704,5026,115076,4500214224,,3000938529,2.2655E+12,5026604800,40,1331.55 need them to be like this, one CSV file
BOL,SAP Shipment,Ship From,Ship To,P.O. Number,SAP Transfer,LPN,Material Code,Batch Code,Cases,Weight 81171262,81171262,5026,115075,4500214105,,3000935271,2265536614,5026604900,36,2106.14 81171262,81171262,5026,115075,4500214105,,3000935291,2265536614,5026604900,36,2116.94 81171262,81171262,5026,115075,4500214105,,3000935293,2265536614,5026604900,36,2123.99 81171262,81171262,5026,115075,4500214105,,3000935298,2265536614,5026604900,36,2118.89 BOL,SAP Shipment,Ship From,Ship To,P.O. Number,SAP Transfer,LPN,Material Code,Batch Code,Cases,Weight 81171704,81171704,5026,115076,4500214224,,3000935280,2.2655E+12,5026604900,40,1326.98 81171704,81171704,5026,115076,4500214224,,3000938276,2.2655E+12,5026604800,40,1326.44 81171704,81171704,5026,115076,4500214224,,3000938529,2.2655E+12,5026604800,40,1331.55
|