How to remove columns from a csv file with PHP?

Question

I know the names of the columns I want to keep in the .csv file, but I am interested in removing all columns in the .csv which I don't recognize. How can php do this?

(The names of the columns are defined in the first row of the file.)

May I ask why? Whenever I parse CSV files, I simply ignore the columns I don't need. — Quasipickle
– Quasipickle, Commented Nov 9, 2010 at 15:52
@Pickle The script I have written is returning duplicate columns errors when I try to import it into a database, I suppose I am more interested in getting rid of columns that I don't recognize to avoid duplication. I suppose there can be another approach to this. — Alex
– Alex, Commented Nov 9, 2010 at 15:55
A similar question worth looking at: stackoverflow.com/questions/9814272/… — mOrloff
– mOrloff, Commented Jun 13, 2014 at 17:59

Scott · Accepted Answer · 2010-11-09 15:56:01Z

1

In PHP use fgetcsv() to read in your CSV file, ignore the columns you want and then write back to a CSV file using fputcsv();

answered Nov 9, 2010 at 15:56

Scott

3,98710 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Veign · Accepted Answer · 2010-11-09 15:56:01Z

0

Look at fgetcsv and fputcsv. Read the contents, write the columns/data back out that you want.

answered Nov 9, 2010 at 15:56

Veign

6164 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to remove columns from a csv file with PHP?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related