Thread String zu hash wandeln + CSV (10 answers)
Opened by crypt0 at 2005-03-13 23:15

renee
 2005-03-14 16:32
#52624 #52624
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
use DBI;
use Data::Dumper;

my $dbh = DBI->connect("DBI:CSV:f_dir=C:/;csv_sep_char=\t")
or die $DBI::errstr;
$dbh->{'csv_tables'}->{'info'} = { 'file' => 'info.csv'};
my $sth = $dbh->prepare("SELECT PartID FROM info");
$sth->execute();

my %hash;
while(my $test = $sth->fetchrow_hashref){
unless($hash{$test->{PartID}}){
$hash{$test->{PartID}} = 1;
}
else{
print "Schon vorhanden: ",$test->{PartID},"\n";
}
}

print Dumper(\%hash);
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread String zu hash wandeln + CSV