Re: Reading and writing data to text file and to table

Why not represent your data in the way you wish to present it? create a 2-dimensional array using the line number of the file as your index when reading in the data.

subroutine{

    my @data;
    my $table;

    open( F, "$File" )
      || die("Could not open $File");
    
    while (<F>) {
        chomp();
        push( @{@data[$.]},( split /,/, $line));
    }
    close(F);

    $table .= "<table border=1>";

    for my $i ( 0 .. $#data ) {
        $table .= "<tr>";
        for ( @{@data[$i]}){
            $table .= "<td>$_</td>\r\n";
        }
        $table .= "</tr>";
    }
    $table .= "</table>";
}
[download]

print "Good ",qw(night morning afternoon evening)[(localtime)[2]/6]," fellow monks."

Comment on Re: Reading and writing data to text file and to table Select or Download Code

Replies are listed 'Best First'.
Re^2: Reading and writing data to text file and to table by learner@perl (Novice) on Jul 03, 2013 at 06:51 UTC
Hi Masters, Please find the records which i formed below `$input{$EMPNO}[0]="DOB,Name,Empid,salary,Gross_salary,Department,Compa +ny"; $input{$EMPNO}[1]="Month,NET_Salary,";` [download] The code which is used to put the records in table `{ my @data; my $table; foreach my $k (keys %input) { foreach (@{$input{$k}}) { chomp(); push( @{@data[$.]},( split /[,\n]/, $_)); } } $table .= "<table border=1>"; for my $i ( 0 .. $#data ) { $table .= "<tr>"; for ( @{@data[$i]}){ $table .= "<td>$_</td>\r\n"; } $table .= "</tr>"; } $table .= "</table>"; }` [download] The output i want in a tabular format, when i run the above code i have error,Can't use an undefined value as an ARRAY reference	[reply] [d/l] [select]
Re^3: Reading and writing data to text file and to table by learner@perl (Novice) on Jul 03, 2013 at 07:11 UTC
Hi Masters, Good Morning, i am creating some records by adding some variables to it as mentioned below `$report{}[0]="DOB,Name,Empid,salary,Gross_salary,Department,Company"; $report{}[1]="Month,NET_Salary,";` [download] I need to print these records to text file and also to a table `subroutine{ my @data; my $table; open( F, "$File" ) \|\| die("Could not open $File"); while ( my $line = <F> ) { chomp($line); push( @data,( split /[,\n]/, $line));} close(F); $table .= "<table border=1>"; for my $i ( 0 .. $#data ) { $table .= "<tr>"; for ( @data[$i]){ $table .= "<td>$_</td>\r\n"; } $table .= "</tr>"; } $table .= "</table>"; }` [download] When i execute this code, i am getting output as: `MessageFile MessageFile MessageFile MessageFile MessageFile` [download] How can i read those records and print them into to text file and also to a table, any help on this, thanks in advance I have changed the code from for ( @data$i){ for column, i am getting output in single coulmn `DOB Name Empid salary Gross_salary Department Company Month NET_Salary` [download] Its not displaying the data in row and column	[reply] [d/l] [select]