If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

PHP CSV columns into arrays

Placebo · 2010-03-11 13:50:14

Basically, i want to make a system where a user can upload a CSV file and pick what columns they want to upload/process I can do this fine by using fopen and foreach, but since the number of the column may vary from CSV to CSV.... i can store the picked columns in an array, eg picked[]= "1,2,4"; //from 1,2,3,4 columns…

Options

11-03-2010 2:50pm

#1
Placebo

Registered Users Posts: 8,070 ✭✭✭

Join Date: September 2002

Posts: 7411
Basically, i want to make a system where a user can upload a CSV file and pick what columns they want to upload/process

I can do this fine by using fopen and foreach, but since the number of the column may vary from CSV to CSV....

i can store the picked columns in an array, eg picked[]= "1,2,4"; //from 1,2,3,4 columns
comma seperated or anyway i want.

but how can i use something like list(1,2,4) = explode("," , theData[]);

where i can load 1,2,4, in there dynamically, or even 1,2,3,4 and then i can ignore 3.

Tagged:

php

csv

0