Your data seems a bit weird (different amount of columns) - but try this ugly solution using paragraph mode:

#!/usr/bin/env perl

use strict;
use warnings;
use Data::Dump;

my $file = qq(AMS.csv);

local $/ = "";

open( my $fh, "<", $file ) || die $!;
my @array = <$fh>;
close $fh;

# dd \@array;

my @one   = split /\n/, $array[0];
my @two   = split /\n/, $array[1];
my @three = split /\n/, $array[2];

# dd \@one, \@two, \@three;

my ( $result, $year, $department );

for my $item (@one) {
    if ( $item =~ /(^1,)/ ) {
        $item =~ s/$1//;
        $year       = ( split /,/, $two[0] )[1];
        $department = ( split /,/, $three[0] )[1];
        $result .= qq($year,$item,$department\n);
    }
    if ( $item =~ /(^2,)/ ) {
        $item =~ s/$1//;
        $year       = ( split /,/, $two[1] )[1];
        $department = ( split /,/, $three[1] )[1];
        $result .= qq($year,$item,$department\n);

    }
    if ( $item =~ /(^3,)/ ) {
        $item =~ s/$1//;
        $year       = ( split /,/, $two[2] )[1];
        $department = ( split /,/, $three[2] )[1];
        $result .= qq($year,$item,$department\n);

    }
}

#print $result;
open my $out, ">", "PPS.csv" || die $!;
print $out $result;
close $out;

__END__

karls-mac-mini:monks karl$ ./ksh.pl

karls-mac-mini:monks karl$ cat PPS.csv 
2002,Go,Manuel,V.,1/22/2015,8:30AM,5:30PM,1001,IT
2001,Calinisan,Peter,S.,1/22/2015,8:30AM,5:30PM,1002,HR
2003,Sioting,Michael,S.,1/22/2015,8:30AM,5:30PM,1003,PURCHASING

[download]

Update: I skipped the wrapper thing, OK...

Update2: Actually it isn't "ugly".

Best regards, Karl

«The Crux of the Biscuit is the Apostrophe»

In reply to Re: pl c sv text format wrap by karlgoethebier
in thread pl c sv text format wrap by edrew04

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.