Shell Programming and Scripting

cat foo
make,model,engine,trim,value
bmw,530,3.0,sport,20000
merk,E180,1.8,amg,16000

current code & result (working):

sed -n '1p;/merk/p' foo|awk -F, 'NR==1{for(i=1;i<=NF;i++)if($i==v)c=i};NR>1{print $1" "$c}' v=value
merk 16000

desired result:

make, value
merk, 16000

awk -v s="merk" 'NR==1 || $0~s{print $1, $NF}' FS=, OFS=, foo

awk -v s="merk" 'NR==1{f=1} {for(i=1; i<=NF; i++) if($i==s) f=1} f{print $1, $NF; f=0}' FS=, OFS=, foo

[akshay@nio tmp]$ cat header 
make
value

[akshay@nio tmp]$ cat file
make,model,engine,trim,value
bmw,530,3.0,sport,20000
merk,E180,1.8,amg,16000

[akshay@nio tmp]$ cat parse.awk 
NR==FNR{
                Cols = Cols (length(Cols)?"|":"")$1
                next
       }
 FNR==1{
                for (i=1;i<=NF;i++) 
                if (match($i,Cols)) 
                Ar[++n]=i
       }

       {
               for (i=1;i<=n;i++) 
               printf (i<n)? $(Ar[i])  OFS : $(Ar[i])
               printf "\n"
       }

[akshay@nio tmp]$ awk -vFS="," -vOFS="," -f parse.awk  header  file
make,value
bmw,20000
merk,16000

awk -F, 'NR==1{for(i=1;i<=NF;i++)if($i==v)c=i};NR==1 || $0~s{print $1, $c}' FS=, OFS=, s=merk v=engine foo

awk 'NR==1{split($0,F); for(i in F) N[F[i]]=i} NR==1 ||$0~s{print $1, $N[v]}' FS=, OFS=, s=merk v=engine foo