1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

#!/usr/bin/perl

# sollte in keinem Script fehlen
use strict;
use warnings;

# DBI Modul Laden
use DBI;

# Verbindung aufbauen
my $dbh = DBI->connect('DBI:CSV:f_dir=/home/ritter/Desktop');

# Testausgabe
my $sth=$dbh->prepare('SELECT * FROM prospects.csv');
$sth->execute();
while(my @row = $sth->fetchrow_array)
{ print join(' ',@row)."\n";
}

$sth->finish();


$dbh->disconnect();

Quote

Charlotte French Cakes 1179 Glenhuntly Rd 1 Y John
Glenhuntly Pharmacy 1181 Glenhuntly Rd 1 Y Paul
Dick Wicks Magnetic Pain Relief 1183-1185 Glenhuntly Rd 1 Y George
Gilmour's Shoes 1187 Glenhuntly Rd 1 Y Ringo

Quote

"Name","Address","Floors","Donated last year","Contact"
"Charlotte French Cakes","1179 Glenhuntly Rd","1","Y","John"
"Glenhuntly Pharmacy","1181 Glenhuntly Rd","1","Y","Paul"
"Dick Wicks Magnetic Pain Relief","1183-1185 Glenhuntly Rd","1","Y","George"
"Gilmour's Shoes","1187 Glenhuntly Rd","1","Y","Ringo"