Select Code to Download

Master file
employee ID, name, surname, other fields
...
2, aa, bb,..
3,cc,dd,..
4, ee, ff

employee ID, name, surname, other fields
1,nitin1, abc1,...
2, aa1, bb1,..
3,cc1,dd1,..
4, ee11, ff1

Employee Number~Category Number~Forename~Surname~Initials~NI Number~Ti
+tle~Gender~Marital Status~Date of Birth~Home Address Line 1~Home Addr
+ess Line 2~Home Address Line 3~Home Town/City~Home County~Home Post C
+ode~Employee Contribution %~Employer Contribution %~Annual Salary~Dat
+e of Joining Scheme~Date of Joining Company~Exchanged %~Scheme Joiner
D51231~ORDM~Charles~Smith~C T~NP307342C~Mr~Male~S~15/10/1971~45 Board 
+Walk~Springer Lane~Mundesley~Norfolk~~NR28 3JK~0.00~8.00~72800.00~01/
+09/2014~04/08/2014~2.00~N
F78321~SMG1~Janet~Patterson~J M~AA112233A~Ms~Female~~21/07/1975~12 She
+ringham Way~Cromer~~~~NR21 9BG~0.00~31.00~320000.00~01/09/2014~25/08/
+2014~0.00~N

Employee Number~Category Number~Forename~Surname~Initials~NI Number~Ti
+tle~Gender~Marital Status~Date of Birth~Home Address Line 1~Home Addr
+ess Line 2~Home Address Line 3~Home Town/City~Home County~Home Post C
+ode~Employee Contribution %~Employer Contribution %~Annual Salary~Dat
+e of Joining Scheme~Date of Joining Company~Exchanged %~Scheme Joiner
D51231~ORDM~Nitin~Rane~C T~NP307342C~Mr~Male~S~15/10/1971~45 Board Wal
+k~Springer Lane~Mundesley~Norfolk~~NR28 3JK~0.00~8.00~72800.00~01/09/
+2014~04/08/2014~2.00~N
F78321~SMG1~AAA~BBB~J M~AA112233A~Ms~Female~~21/07/1975~12 Sheringham 
+Way~Cromer~~~~NR21 9BG~0.00~31.00~320000.00~01/09/2014~25/08/2014~0.0
+0~N

my $dbh = DBI->connect('dbi:CSV:', "", "",
             {
...
use Data::Dumper;
print  $res;

 my $dbh = DBI->connect("dbi:CSV:f_dir=$_ENV::LogsFilesDIR;csv_sep_cha
+r=\\~") or die $DBI::errstr;
$dbh->{'csv_tables'}->{'prospects'} = { 'file' => 'cimp_new_entrant.tx
+t'};
...
   $sth->finish( );
   $dbh->disconnect( );