AWK: Inserir cópia da coluna no meio do csv

Question

Exemplo csv:

AAA, BBB, CCC, DDD, EEE, FFF, GGG, HHH

Agora, eu não quero copiar uma coluna 2 (BBB) e adicioná-la na frente da coluna 3 para que o arquivo se pareça com:

AAA, BBB, BBB, CCC, DDD, EEE, FFF, GGG, HHH

    

Answer 1

$ cat test.txt
AAA, BBB, CCC, DDD, EEE, FFF, GGG, HHH
AAA, BBB, CCC, DDD, EEE, FFF, GGG, HHH
AAA, BBB, CCC, DDD, EEE, FFF, GGG, HHH

$ awk -F, '{$2=$2","$2}1' OFS=, test.txt
AAA, BBB, BBB, CCC, DDD, EEE, FFF, GGG, HHH
AAA, BBB, BBB, CCC, DDD, EEE, FFF, GGG, HHH
AAA, BBB, BBB, CCC, DDD, EEE, FFF, GGG, HHH

    

Answer 2

awk '{print $1,$2,$2,$3,$4,$5,$6,$7,$8}' file.csv

Exemplo:

 ➤ echo "AAA, BBB, CCC, DDD, EEE, FFF, GGG, HHH" | awk '{print $1,$2,$2,$3,$4,$5,$6,$7,$8}'
 AAA, BBB, BBB, CCC, DDD, EEE, FFF, GGG, HHH