Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Answer: structured printing of arrays

by graff (Chancellor)
on Apr 24, 2003 at 03:55 UTC ( #252761=categorized answer: print w/replies, xml ) Need Help??

Q&A > arrays > structured printing of arrays - Answer contributed by graff

There is a handy module on CPAN called Data::ShowTable, which provides the pretty borders and handles a lot of the busywork of formatting the table output, but using it effectively for this sort of thing still involves some work -- you have to tell it what the maximum column widths are that you want for your table (and if you hand it data that doesn't fit within those widths, it will do an adequate, readable, but not-so-pretty job if wrapping the contents within a table cell, so no information is lost). Here's a relevant sample of usage -- I never used this module before, and I figured out the example based on reading the man page (so the documentation for this module is good):
use Data::ShowTable; my @AoA = ( [ qw/id user_lvl first_name last_name surname homepage/ ], [ '1', '50', 'unknownlengh', '', ' ', 'none' ], [ qw/5000 0 Joe Papadakolopolous AlsoTooLong www.younameit ], ); my $header = shift @AoA; # extract the column labels to a separate ar +ray # You can set "default" column widths to be the lengths of # the column header strings, like this: my @colwidth = map { length() } @$header; # If you don't do at least that much work to initialize # column widths, you probably won't like the output. # figure out the maximum data widths for each column; these will have +an # effect on output when they happen to be wider than the corresponding # column header string: my @colwidth; for $row ( @AoA ) { for ( $col=0; $col<@$row; $col++ ) { my $l = length( $$row[$col] ); $colwidth[$col] = $l if ( $colwidth[$col] < $l ); } } # Note that the args this and other ShowTable methods are all REFERENC +ES: ShowBoxTable $header, [qw/int int text text text text/], \@colwidth, \ +&rowsub; # Here's the sub that ShowTable needs so that it can fetch # one row of data per call: sub rowsub { my $arg = shift; if ( $arg ) { return; } elsif ( scalar @AoA ) { my $rowref = shift @AoA; return (@$rowref); } else { return; } }

Replies are listed 'Best First'.
Re: Answer: structured printing of arrays
by hacker_j99 (Beadle) on Apr 29, 2003 at 06:14 UTC
    Thanks anyway but I found works just as well and does most things for me. in either ascii or in html table format
    #!/eng/local/bin/perl # table maker require '/home/top/hfranks/perl/'; # database hack require "../"; require "../"; #new table $t = new Text::ASCIITable; $user="hfranks"; @id=mysql_handeler('select uid from users_student where name="'.$user. +'";'); $uid=$id[1]; #mysql statements @res=mysql_handeler('select * from EECS2550 where uid="'.$uid.'";'); chomp @res; #column title @top=split(/ /, shift(@res)); #remove 2 unwanted auto_increment fields shift (@top); shift (@top); $t->setCols(\@top); #get rows foreach $line (@res){ chomp $line; @ary = split(/ /, $line); #remove two unwanted auto_increment fields shift (@ary); shift (@ary); $t->addRow(@ary); } #print it #normal ascii output #$cOntent .= $t->draw(); #advanced html output $cOntent.=$t->draw( ['<table border="1">','','',''], # <table><tr></tr> ['<tr><td>','</td></tr>','</td><td>'], ['','','',''], ['<tr><td>','</td></tr>','</td><td>'], ['','</table>','',''], ); my $template = "../template.html"; my %gTokens=(); my $key="<!--something-->"; $gTokens{"$key"} = $cOntent; &SendTemplate($template,%gTokens);

    html result

    test1 test2 test3 quiz1 homework final
    100 100 100 10 100 100
Log In?

What's my password?
Create A New User
[vedagiri89]: hi all! i need your help
[vedagiri89]: i'm facing this issue: Attempt to reload aborted.\ nCompilation failed in require at /usr/lib64/perl5/ vendor_perl//APR. pm line 19.\nBEGIN failed--compilatio n aborted at /usr/lib64/perl5/ vendor_perl//APR. pm line 19.
[vedagiri89]: how do fix this issue
[choroba]: This usually happens when you have more than one version of Perl, and you mix the libraries
[hippo]: Which O/S?
[vedagiri89]: i have searched many forum...not getting resolutions
[vedagiri89]: centos
[Corion]: vedagiri89: Either what choroba said, or maybe you misspelled some module name (on Windows), like use Strict; or something like that.
[vedagiri89]: @choroba, what to do for that

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (7)
As of 2018-06-19 11:15 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (113 votes). Check out past polls.