TIMTOWTDI via DBD::CSV:
use DBI;
use Data::Dumper;
use strict;
my $dir = '.';
my $file = 'simple_csv';
my $cols = [qw(one two three)];
my $dbh = DBI->connect(
"DBI:CSV:f_dir=$dir;csv_eol=\n;csv_sep_char=:;",
{RaiseError=>1},
);
$dbh->{csv_tables}->{$file} = { col_names => $cols };
my $sth = $dbh->selectall_arrayref("
select one, two, three
from simple_csv
order by two
");
print Dumper $sth;
This assumes that you are in the same directory as the
CSV file and the CSV file is named 'simple_csv' - note
there is no extension in the file name. Read the docs for
more info. Here is the sample CSV file i used:
simple_csv
three:place3:baz
two:place2:bar
four:place4:qux
one:place1:foo
jeffa
L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|