how to cut the selected columns from the file.
load.sh students.csv | select.sh ‘name’ ‘school_name’
This will output the name and school_name columna from the loaded file to the terminal.
csvsql from csvkit:
csvcut -c name,school_name students.csv csvsql --query 'select name, school_name from students' students.csv
$ cat students.csv id,name,surname,school_name,favorite_color 1,Tom,Sawyer,Harvard,red 2,Bob,"the Builder",Oxford,orange 3,John,Sinclair,"Columbine High",blue 4,Walter,Mitty,"Thomas Jefferson High",green 5,Donald,Trump,Unknown,blue $ csvcut -c name,school_name students.csv name,school_name Tom,Harvard Bob,Oxford John,Columbine High Walter,Thomas Jefferson High Donald,Unknown