How to get the line number of a CSV file?

[lopes_andre]

Hi,

 

I'm using the "fgetcsv" function to read a CSV file. I need to count the total number of lines in a CSV file and go to X line. Which the best way of doing it?

 

Best Regards,

André.

 

[trq]

There is no real good way of doing it. You'll need to open the file, read the entire thing into an array, count the size of the array, then loop back through 9the array) until you get to the line you want.

 

You'll probably have no use for fgetcsv by then.

[lopes_andre]

Hi,

 

Thanks for the reply.

 

It is a good idea to store in one array 200MB of data or should be better to get the lines of the CSV one by one?

 

The deal is that I have a 200MB CSV file that I need to write the INSERT's INTO to put in the database, but I don't know if it is a good idea to store the data in one array or construct the INSERTS one by one in a loop.

 

Best Regards,

 

[PFMaBiSmAd]

Why do you need a count of the number of lines and the ability to goto line x if all you need to do is insert the data into a database table?

[lopes_andre]

Hi,

 

Thanks for the reply.

 

I need to get the line number because, the first line of the CSV contain the Headers. It is not strictly necessary but I'm doing a generic class do deal with CSV's.

[PFMaBiSmAd]

Detecting the first line and either skipping over it or reading the field names from it has nothing to do with a count of the number of the total lines or the ability to goto line x. I would say you are over complicating this.

[lopes_andre]

I reach the same conclusion.

 

The files are very big to handle with goto line X.

 

I have a method that get me the Headers and other method that do me the Inserts Into on-the-fly.

 

Thanks for the help.