shell - Search for a column by name in awk -
i have file has many columns. let "employee_number" "employee_name" "salary". want display entries in column giving or part of column name. example if input "name" want employee names printed. possible in simple manner using awk? thanks
given script getcol.awk follows:
begin { colname = argv[1] argv[1] = "" getline (i = 1; <= nf; i++) { if ($i ~ colname) { break; } } if (i > nf) exit } {print $i} ... , input file test.txt:
apple banana candy deer elephant b c d e b c d e b c d e b c d e b c d e b c d e b c d e ... command:
$ awk -f getcol.awk b <test.txt ... gives following output:
b b b b b b b note output text not include first line of test file, treated header.
Comments
Post a Comment