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
By the way, I tested if Excel (2000) is able to handle new lines in tab
delimited files. And it was not. On the other hand, Excel is able to
handle new lines in CVS files.
On Tue, 2004-02-17 at 10:24, Svensson, B.A.T. (HKG) wrote:
> And what will then happen when you data contains tabs?
>
>
> On
And what will then happen when you data contains tabs?
On Tue, 2004-02-17 at 09:24, Angelo Zanetti wrote:
> 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, 20
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 where
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
