CmdID

CmdID / Commands

textql

Execute SQL against structured text like CSV or TSV files. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Print the lines in the specified CSV file that match an SQL query to stdout

textql -sql "SELECT * FROM filename" path/to/filename.csvIdentify

Query a TSV file

textql -dlm=tab -sql "SELECT * FROM filename" path/to/filename.tsvIdentify

Query file with header row

textql -dlm=delimiter -header -sql "SELECT * FROM filename" path/to/filename.csvIdentify

Read data from stdin

cat path/to/file | textql -sql "SELECT * FROM stdin"Identify

Join two files on a specified common column

textql -header -sql "SELECT * FROM path/to/file1 JOIN file2 ON path/to/file1.c1 = file2.c1 LIMIT 10" -output-header path/to/file1.csv path/to/file2.csvIdentify

Format output using an output delimiter with an output header line

textql -output-dlm=delimiter -output-header -sql "SELECT column AS alias FROM filename" path/to/filename.csvIdentify