Subject: Re: [PHP-WIN] HELP CSV's
If I was to save an excel file as CSV file, would the file then just
contain a list of values (the excel cell values) delimited by commas? No
column headings(assuming Excel allows column headings).
Cheers
Tryst
--
PHP Windows Mailing List (http://www.ph
If I was to save an excel file as CSV file, would the file then just contain a list of
values (the excel cell values) delimited by commas? No column headings(assuming Excel
allows column headings).
Cheers
Tryst
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://ww
On Tue, 2004-02-17 at 08:39, idrifter wrote:
> As far as the newline characters I don't know if its
> feasible for your particular project but you could
> strip the newline characters out with something like
> this:
If the CSV file is proper formated, then Excel will be able
to handle those new l
bruary 17, 2004 8:16 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-WIN] HELP CSV's
> >
> >
> > Good day to you All,
> >
> > Hi Im working on a project where it is nessary to download the values of the
> > tables in the database and
> > format the
esday, February 17, 2004 8:16 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] HELP CSV's
>
>
> Good day to you All,
>
> Hi Im working on a project where it is nessary to download the values of the
> tables in the database and
> format them in csv (comma separated v
The trivial standard solution is to quote the entries, and quote quotes
inside the entires.
On Tue, 2004-02-17 at 07:15, dwight ian wrote:
> Good day to you All,
>
> Hi Im working on a project where it is nessary to download the values of the tables
> in the database and
> format them in csv
you could also delimit the fields by tab spaces (tab delimited) use
google...
-Original Message-
From: dwight ian [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 8:16 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] HELP CSV's
Good day to you All,
Hi Im working on a project
To get around the comma problem you can enclose your
fields in quotes:
"column 1 da,ta","colu,mn 2 data","column,3 data"
As far as the newline characters I don't know if its
feasible for your particular project but you could
strip the newline characters out with something like
this:
$new_string
Good day to you All,
Hi Im working on a project where it is nessary to download the values of the tables in
the database and
format them in csv (comma separated values) files in order for them to be viewed in a
spreadsheet
application (ie Microsoft Excel).
The problem happens when the value
