Re: Delimited file values behaving strangely...

From: Date: Mon, 10 Feb 2003 16:21:16 +0000
Subject: Re: Delimited file values behaving strangely...
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-135085@lists.php.net to get a copy of this message
I'm guessing it containt a trailing space, which wouldn't display in HTML. Try trim()ing it. Geoff Caplan wrote:
Hi folks, A strange one - unless I am having a brainstorm... I am reading in tab delimited files created in Excel on Windows and uploaded to Linux. Cell A1 contains a numeric id - I extract this into a variable, $id, by exploding on \n and \t. But for some files, the values of $id do not behave as expected. Say the value should be "23". If I echo, it prints as "23". But comparisons fail to match: if( $id == 23 ) ... It also fails if I try to find the value as a key in an array: if( isset( $my_array[$id] ) ) ... On the other hand, values from some of the files work as expected. One clue: if I try and cast the values that are failing to int, the cast produces the value 0 (zero). On the other hand, the values that are working as expected cast from, say, the string 22 to the int 22 as expected. Never seen anything like this before - can anyone give me a pointer??
-- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

« previous php.general (#135085) next »