Re: parsing csv-file for inserting in database

2007-09-19 Thread Ruprecht Helms
Hi, On running the script I get the following errors: Scalar found where operator expected at ./csv_auslesen.pl line 29, near pint Auftrag $Datenfelder (Might be a runaway multi-line string starting on line 3) (Do you need to predeclare pint?) Backslash found where operator expected

RE: parsing csv-file for inserting in database

2007-09-19 Thread Andrew Curry
open(CSV,Kalkulation_Tauchsportportal.csv) || die CSV-Datei nicht gefunden\; you have \ your -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: 19 September 2007 10:40 To: Chas Owens Cc: Jonathan Lang; beginners@perl.org Subject: Re: parsing csv-file for inserting

RE: parsing csv-file for inserting in database

2007-09-19 Thread Andrew Curry
@Datenfelder = split(/,,,$Felder); Guessing this line. Split (//,$string) -Original Message- From: Ruprecht Helms [mailto:[EMAIL PROTECTED] Sent: 19 September 2007 15:00 To: Andrew Curry Cc: Chas Owens; Jonathan Lang; beginners@perl.org Subject: Re: parsing csv-file for inserting

Re: parsing csv-file for inserting in database

2007-09-19 Thread Ruprecht Helms
Andrew Curry wrote: open(CSV,Kalkulation_Tauchsportportal.csv) || die CSV-Datei nicht gefunden\; you have \ your Ok I corrected it, now I only have an syntax-error in line 25 (split-command). In addition i am told that the part is not terminated. The actual code is: #!/usr/bin/perl

Re: parsing csv-file for inserting in database

2007-09-19 Thread Chas Owens
On 9/19/07, Ruprecht Helms [EMAIL PROTECTED] wrote: #!/usr/bin/perl First off, you should use the strict and warnings pragmas. So the first two lines after the $! should be use strict; use warnings; open(CSV,Kalkulation_Tauchsportportal.csv) || die CSV-Datei nicht gefunden; $i=0;

Re: parsing csv-file for inserting in database

2007-09-19 Thread Ruprecht Helms
Chas Owens wrote: On 9/19/07, Ruprecht Helms [EMAIL PROTECTED] wrote: #!/usr/bin/perl First off, you should use the strict and warnings pragmas. So the first two lines after the $! should be use strict; use warnings; ... I inserted the two commands and get now these errors. Scalar

Re: parsing csv-file for inserting in database

2007-09-19 Thread Chas Owens
On 9/19/07, Ruprecht Helms [EMAIL PROTECTED] wrote: Chas Owens wrote: On 9/19/07, Ruprecht Helms [EMAIL PROTECTED] wrote: #!/usr/bin/perl First off, you should use the strict and warnings pragmas. So the first two lines after the $! should be use strict; use warnings; ... I

Re: parsing csv-file for inserting in database

2007-09-17 Thread Chas Owens
On 9/16/07, Ruprecht Helms [EMAIL PROTECTED] wrote: Hi, how can I parse a csv-file where the entries are seperated with | . The scripts later should put them into a mysql-database using dbi. Especially for me is interessting how to parse the content of the file and store them into

Re: parsing csv-file for inserting in database

2007-09-17 Thread Jonathan Lang
Ruprecht Helms wrote: Hi, how can I parse a csv-file where the entries are seperated with | . The scripts later should put them into a mysql-database using dbi. Especially for me is interessting how to parse the content of the file and store them into different variables for later

Re: parsing csv-file for inserting in database

2007-09-17 Thread Chas Owens
On 9/17/07, Jonathan Lang [EMAIL PROTECTED] wrote: snip Most of the replies have suggested using 'split( /\|/, $line )'. However, this ignores a potentially important aspect of common cvs file formats - well, important to me, anyway - which is the interaction between quotes, field delimiters,

Re: parsing csv-file for inserting in database

2007-09-17 Thread Ken Foskey
On Mon, 2007-09-17 at 13:34 -0700, Jonathan Lang wrote: Most of the replies have suggested using 'split( /\|/, $line )'. However, this ignores a potentially important aspect of common cvs file formats - well, important to me, anyway - which is the interaction between quotes, field delimiters,

parsing csv-file for inserting in database

2007-09-16 Thread Ruprecht Helms
Hi, how can I parse a csv-file where the entries are seperated with | . The scripts later should put them into a mysql-database using dbi. Especially for me is interessting how to parse the content of the file and store them into different variables for later processing. A scriptexample would

Re: parsing csv-file for inserting in database

2007-09-16 Thread Ken Foskey
On Sun, 2007-09-16 at 12:28 +0200, Ruprecht Helms wrote: Hi, how can I parse a csv-file where the entries are seperated with | . The scripts later should put them into a mysql-database using dbi. if it just splitting: @data = split( /\|/, $line ); If you forget the backslash it will

Re: parsing csv-file for inserting in database

2007-09-16 Thread Ruprecht Helms
Hi Ken, how can I parse a csv-file where the entries are seperated with | . The scripts later should put them into a mysql-database using dbi. if it just splitting: @data = split( /\|/, $line ); I see you are working with array. The using of the for each-loop must be possible for