Fake fgetcsv(), do you?

[Anon]

I had to rebuilt some of my code yesterday because the hosting service had only PHP 3.0.6 installed and I used the nifty CSV function fgetcsv() to extract content from a CSV spreadsheet into a WAP site.
When I realized the version compatability touble I tried to make my own faked fgetcsv() in PHP.

What I did was the I used fgets() and I looked for , commas to separate "columns".
The problems is if you enter a , comma in a column, my faked code doesn't cope for that.

Is there anyone out there who has solved this problem before, with a solid function or method?

[Anon]

Hi Peter,

the problem with the delimiter stays the same if you could use fgetcsv().
Since I am working a lot with fgetcscv() I just changed the delimiter from a comma (,) to a pipe (|).
In the standard function this is the optional third parameter. If you created your own function, just check for a pipe, since this character is not so commonly used by users as input char.
You might want to check for certain other characters of course....
depends a lot on the type of input your function gets....

Hope that helped,
FAB

[Anon]

But the contentmanager writing the stuff into M$ Excel and then he saves it as a CSV file for me.
And as far as I know there is no option in Excel to save it with | instead of ,

[Anon]

You can save the data from Excel as Tab-separated values and then split the data in PHP on "\t" or first use a word-processing program to replace the tabs with pipes.

Lauren