php CSV import generated from MS Excel

Question

and a CSV file generated from MS Excel, I wonder how can we import CSV file in php in this case:

normally, CSV cells are not enclosed in double quotes ("), but will be enclosed when there is a comma (,), double quote (") or new line character (\n) in cell value.
double quotes in cell are replaced with twice double quotes (" => "").
e.g. testCell 1,"test,comma cell 2","testCell ""double quote"" 3",testCell 4

Now, the issue is, how can we identify/separate each cell while reading such CSV as the cells may be enclosed with double quote or may not be.

possible duplicate of parse csv file php, How to parse csv in PHP having multiline data in a column — outis
– outis, Commented Dec 26, 2011 at 7:35
@outis I don't know about that. Excel usually outputs CSV that's nonstandard compliant. fgetcsv doesn't like it one bit. — Phoenix
– Phoenix, Commented Dec 26, 2011 at 7:37
@Phoenix: maybe, but fgetcsv works with both the specific case described and the test data. — outis
– outis, Commented Dec 26, 2011 at 7:41

Kulin Choksi · Accepted Answer · 2012-12-27 12:51:45Z

0

@outis: you were right (fgetcsv works with both the specific cases). Issue was with parsing some German characters before applying fgetcsv.

answered Dec 27, 2012 at 12:51

Kulin Choksi

7611 gold badge11 silver badges31 bronze badges

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

1 Answer 1