SED delete csv column if exists I need to remove a column from my tabulated CSV file if this column exists. My CSV file: GENE REF ALT AKT A G AKT G G Desired output: if column REF exists delete this column GENE ALT AKT G AKT G I tried to do that: sed 's/\tREF.[^\t]*//' filename.csv but it doesn't work.

Hi with miller (< and this input.csv


GENE,REF,ALT
AKT,A,G
AKT,G,G


is very easy


mlr --csv cut -x -f REF input.csv


The output is


GENE,ALT
AKT,G
AKT,G