UNIX for Advanced & Expert Users

ABC,A19907103,ABC DEV YUNG,2.17,1000,2157,07/07/2006
XYZ,H00213850,MM TRUP HILL,38.38,580,23308,31/08/2010

A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y
A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y

1 2 3 4 5 6 7
7 11 13 15 20 21

/usr/xpg4/bin/awk 'BEGIN {FS="," ; OFS=","} FNR == NR {a[FNR] = $B; next} $A = a[FNR]' B=2 A=4 input.csv output.csv

A,B,C,D,E,F,ABC,H,I,J,A19907103,L,ABC DEV YUNG,N,2.17,P,Q,R,S,1000,2157,07/07/2006,W,X,Y
A,B,C,D,E,F,XYZ,H,I,J,H00213850,L,MM TRUP HILL,N,38.38,P,Q,R,S,580,23308,31/08/2010,W,X,Y

7 11 13 15 20 21 22

awk -F, '
BEGIN{n=split("7 11 13 15 20 21 22", a, " ")}
{
  getline line < "input.csv"
  split(line,b)
  for(i=1;i<=n;i++) {
    $a[i]=b[i]
  }
}1' OFS="," output.csv