Re[2]: [PHP] Delimited file values behaving strangely... SOLVED

2003-02-10 Thread Geoff Caplan
Hi, Of course, I solve it just after I decide to post... For some reason, my customer's spreadsheet data has unusual non-printing characters in some of the fields that weren't showing up in the page source. All I needed to do is strip them out with a regex. Anyway, thanks for the suggestions Ge

Re: [PHP] Delimited file values behaving strangely...

2003-02-10 Thread Guru Geek
When this happens to me I always just echo the variable value like so to see if something is there that shouldn't be: echo ""; echo "$id"; echo ""; obviously all this does is print the variable with a bunch of c's before and after. That way I can see if there are any extra things include

Re: [PHP] Delimited file values behaving strangely...

2003-02-10 Thread Jason Wong
On Tuesday 11 February 2003 00:15, 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 explod

Re: [PHP] Delimited file values behaving strangely...

2003-02-10 Thread Lowell Allen
> From: Geoff Caplan <[EMAIL PROTECTED]> > > 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 \

Re: [PHP] Delimited file values behaving strangely...

2003-02-10 Thread Leif K-Brooks
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 -

[PHP] Delimited file values behaving strangely...

2003-02-10 Thread Geoff Caplan
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