Posted by Erwin Moller on 10/12/05 12:56

Tom wrote:

> PHP Gurus...
>
> Can anyone give me a helping hand with this.
>
> I'm more ASP, but trying to move to PHP and sturggling a bit.
>
> I have a few products stored in a csv file created in Excel. Column 1
> is the part #, column 2 is title, column 3 is color, column 4 is width
> and 5 is price.
>
> I need to read these into arrays, with a seperate array for each
> column.
>
> Can anyone suggest anything?
>
> If someone could point me in the right direction it would be much
> appreciated!
>
> Tom

Hi Tom,

Try something like this:
1) find out what the end-of-line is. Probably \n
2) read the csv into an array using file().
Now each arrayelement is a row from the csv.
check www.php.net for details.

3) Explode each line, using the seperator for columns. (can be tab \t or ,
or whatever you decided.)

Good luck.

Regards,
Erwin Moller

[Back to original message]