UNIX for Dummies Questions & Answers

Name1,Var1,Val1
Name1,Var2,Val2
Name2,Var1,Val3
Name2,Var2,Val4


I want 3 files.

Nameindex

1 Name1
2 Name2
...

Varindex

1 Var1
2 Var2
...

datafile

1 1 Value1
1 2 Value2
2 1 Value3
2 2 Value4

cut -f1 infile | sort -u | cat -n > nameindex

cut -f2 infile | sort -u | cat -n > varindex

BEGIN {
  FS=","
  fileNames="senNames.txt"
  fileVars="senVars.txt"
  fileData="senData.txt"
}
{
  if(!($1 in names)) { names[$1];print ++namesC, $1 >> fileNames}
  if(!($2 in vars))  { vars[$2];print ++varsC, $2 >> fileVars}
  print namesC, varsC, $3 >> fileData
}

awk -F, '
  !($1 in A) { 
    print A[$1]=++c, $1>"name.idx"
  } 

  !($2 in B) {
    print B[$2]=++d, $2>"var.idx"
  }
  
  {
    print A[$1], B[$2], $3>"file.dat"
  }
' file

awk -F, '!($1 in A){print A[$1]=++c, $1>"name.idx"} !($2 in B){print B[$2]=++d, $2>"var.idx"} {print A[$1], B[$2], $3>"file.dat"}' file