Feature request: Count the number of rows

[stevevance]

I often want to count the number of rows in a CSV file, so that I can confirm with the person who produced the file that I've received the same number of rows that they exported from the database that originally holds the data.

[Jmuccigr]

On a Mac? Use the terminal: wc -l filename.csv

wc = word count
-l = lines (not words)

(Not that this isn't a reasonable request, just that there's an easy solution.)

[stevevance]

@Jmuccigr I had already tried that. It reported the correct line count but the wrong row count, because there were line breaks in some of the fields.

[Jmuccigr]

@stevevance Ah, yes, that can be a problem.

[fulldecent]

Can you please propose exactly how this might look in the GUI? Can you please provide a mockup.

[Jmuccigr]

I'd suggest a few options:

1. Put it after the file title, so "Untitled (1,234 rows)". Could get tough with lots of rows.
2. Put it at the bottom with the other metadata.
3. Insert a dummy first column that's just a row number.

[stevevance]

I like the column that has row numbers.

[mcoenca]

From the evil Excel 😈

[ido-ran]

I also can use both total row count and individual row numbers.
Using wc does not cut it for me as I have content with new-line in it which cause wc to count the number of lines, not the number of records.

[weavermedia]

First column idea! +1 🎉