How to validate an uploaded csv/text file with php

Question

I am using the codeigniter and I managed to create an upload system that checks for extension and size.

What I want to do now is to check if those files are tab separated and have a specific number of columns.

Anyone can point me in the right direction?

Thanks.

How about reading this first: http://stackoverflow.com/questions/2450345/how-to-validate-csv-file — Sudhir Bastakoti, Mar 19 '12 at 09:23
I read it before posting the question, it only contains suggestions, but not a straight way to do it. Besides, the approach is different. — biojl, Mar 19 '12 at 09:31

score 3 · Accepted Answer · answered Mar 19 '12 at 09:23

3

Read the first line and use preg_split to split it based on the tab character.

The size of array returned should match the expected number of columns. If not, then the uploaded file is not valid.

answered Mar 19 '12 at 09:23

sikander

score 1 · Answer 2 · edited May 23 '17 at 10:27

1

Use a custom callback function for the form validation. Help on this can be found here.

Help for checking tab delimited here, and number of columns here.

edited May 23 '17 at 10:27

Community

answered Mar 19 '12 at 09:25

Rooneyl

Thanks, your suggestion was also useful. I don't have the reputation to vote you up :( – biojl Mar 19 '12 at 09:34
@sadiqxs It was needed when that question was wrote. I succesfully voted up now :) – biojl Apr 25 '13 at 10:12

2 Answers2