Csv viewer in environement window for 10MM line file

Question

We need a csv viewer that can view 10MM-15MM rows in a Windows environment, and each column can have some filtering (some regular expression or text search).

Answer 1

I highly recommend using the database instead and running queries (e.g. using Access). With proper SQL queries, you can filter the columns you need to see without processing such huge files at the same time. Someone may need to write a script to enter each line of the csv file (and future changes to the csv file) into the database.

Answer 2

. SQL. , , CSV . . , .

, .

" " csv/Excel.

Answer 3

, SQL. . , SQLite FirebirdSQL ().

http://www.sqlite.org/

http://www.firebirdsql.org/manual/ufb-cs-embedded.html

You can easily import CSV into an SQL database with just a few lines of code, and then create an SQL query instead of writing your own solution for filtering large tabular data.