1401,PERISH STORE INV,Quarterly,(V) INV810 USER NAME (EDIT REPORT IF 05309 PRSH INV),EXTRACT WAS RUN),(V) INV820 USER NAME (PERISHABLE INVENTORY REPORT),(VTD8) D:\DEPT\ACCT\MAIL\INV820.DAT,(V) INV820C USER NAME (PERISHABLE INVENTORY-BAKERY),(QUARTERLY RUN ONLY) 1402,PERSH INV BOOKS,Quarterly,(V) INV805 58 COPIES - USER NAME,(V) INV805 2 COPIES - USER NAME,(V) INV805A XTRA COPIES-SAVE IN COMPUTER ROOM,ANNUAL STORE INVENTORY ONLY:,(V) INV805 58 COPIES - USER NAME,(V) INV805 2 COPIES - USER NAME,(V) INV805A XTRA COPIES-SAVE IN COMPUTER ROOM 1403,BAKERY INV BOOKS,Quarterly,(V) INV805 35 COPIES - USER NAME,(V) INV805A 5 COPIES - SAVE IN COMPUTER ROOM,ANNUAL STORE INVENTORY ONLY:,(J) INV805 35 COPIES - USER NAME,(J) INV805A 5 COPIES - SAVE IN COMPUTER ROOM 1501,INV PRICE GUIDE,As Needed,(V) MSC052 BOTH COPIES ARE TO BE PUT IN BINDERS AND,AND LEFT ON THE CABINETS BEHIND THE DP,SECRETARY'S DESK #### 1401,PERISH STORE INV,Quarterly,(V) INV810 USER NAME (EDIT REPORT IF 05309 PRSH INV) 1401,PERISH STORE INV,Quarterly,(EXTRACT WAS RUN) 1401,PERISH STORE INV,Quarterly,(V) INV820 USER NAME (PERISHABLE INVENTORY REPORT) 1401,PERISH STORE INV,Quarterly,(VTD8) D:\DEPT\ACCT\MAIL\INV820.DAT 1401,PERISH STORE INV,Quarterly,(V) INV820C USER NAME (PERISHABLE INVENTORY-BAKERY)(QUARTERLY RUN ONLY) #### #!C:\Perl\bin\perl use strict; use warnings; open INPUT "input.csv"||die "Can not open: $!\n"; open OUTPUT "output.csv"||die "Can not open: $!\n"; while(){ my @line = split /,/; my @line2 = @line[0..2]; my @dist = @line[3..$#line]; my $ref = \@dist; push @line2,$ref; ## Print to OUTPUT } close INPUT; close OUTPUT;