my @avgs  = $dbh->selectrow_array($avgSQL);
print join(",", @cols) . "\n";
print join(",", @avgs) . "\n";
[download]

Excellent! That's awesome. Thank you! I think I even understand what we did! :-)

The approach I was trying to take was an example I found in the Data::Dumper page. I added:

    $Data::Dumper::Pair = ",";
    print Dumper($avgsHashRef);
[download]

I was able to get output in 2 columns, which was good, but it was wrapped with the $VAR1 = {, and the data was indented. I was looking for a way to remove that and just get the data. If I later decide to go with a 2 column output, is there a way to strip that output down?

Thank you again VERY MUCH!

Sure -- you have the colnames in @cols and the values in @avgs, so can just loop over them.

my @avgs  = $dbh->selectrow_array($avgSQL);

# CSV output method A
print join(",", @cols) . "\n";
print join(",", @avgs) . "\n";

# CSV output method B (2-columns)
print "Col,Avg\n";
printf("%s,%f\n", $cols[$_], $avgs[$_]) for 0 .. $#cols;
[download]

Note you can adjust the printf format according if you want a fixed number of decimal places or whatever.


And one more way to do the same thing, which i introduce because it could be handy if you're going to process these avgs at all later in your code. And that is to hash them up for easy access:

my %avgsHash;
@avgsHash{ @cols } = @avgs;  # uses a hash slice to populate %avgsHash
print "Col,Avg\n";
printf("%s,%f\n", $_, $avgsHash{$_}) for @cols;
[download]