How to extract all the data from a csv file

[ComplexPoint]

@mik

1,000 lines x 4 numbers be stretching things?

If scale, datatypes, or available functions ever proved an issue, you could also try this kind of thing:

Simple querying of CSV with sqlite3

From time to time there are questions about extracting data from CSV. One approach is to apply a standard SQL query (simple structure, easily learned) to the CSV data, using sqlite3 which is a built-in macOS command line tool, and requires no installation. Simple querying of CSV with sqlite3.kmmacros (2.7 KB) [Keyboard Maestro Export] [Screenshot 2022-06-21 at 17.38.34]

Expand disclosure triangle to view sqlite3 shell Source

sqlite3 <<"EOF" .mode csv .import '| echo &…