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.
Thank you - I found that very helpful for my use case. A beginners question: is it possible to have a KM variable in the WHERE clause of the SELECT statement? Something like SELECT weekdays, prices FROM csvTable WHERE clientid = "$KMVAR_clientID";
I put much effort in trying all sorts of quoting the "$KMVAR_clientID" but without success.