[kd5bjo]

Awk splits lines into numbered fields, so it’s really convenient for things like extracting and reordering columns from a csv file. For example, getting the second field of every line is:

  awk -F, '{ print $2 }'

[markus_zhang]

I recently tried csvsql and it seemes to be a stronger tool to process csv files?