RE: [PHP] PHP, Excel, and tab delimited files question

From: Date: Mon, 09 Feb 2004 15:50:06 +0000
Subject: RE: [PHP] PHP, Excel, and tab delimited files question
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-177209@lists.php.net to get a copy of this message
Right... But the principal is still the same. Excel handles those types of fields in a uniform way, regardless of whether you do the entry yourself or if you just import a csv file. -- jon -----Original Message----- From: Marek Kilimajer [mailto:kilimajer@webglobe.sk] Sent: Friday, February 06, 2004 5:15 PM To: jon roig Cc: php-general@lists.php.net Subject: Re: [PHP] PHP, Excel, and tab delimited files question jon roig wrote: > Nah... Try it in excel itself and you'll see what I'm talking about. > You have to do it in numeric fields. > > Do this in an excel field: > - Type 000010 and hit return. > ... It becomes 10, right? > > Now try it like this: '000100 > ... Tada! It stays as 00100 and puts a little green tab in the top > left corner. > > There's no closing ' in this example, just the opening one at the > beginning of the text. > > Hope that helps... 'course, I'm using excel 2002, so maybe different > versions do different things... > > -- jon > This is different. You are talking about inputing data in excell application, but Jay is building csv file. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004

« previous php.general (#177209) next »