linux - 转换 d.m.Y h :m:s to Y-d-m h:m:s for a large file in linux

Question

是否可以将 Linux 中的大文件将 d.m.Y h:m:s 转换为 Y-d-m h:m:s？

示例数据

"30.07.2016 00:00:00",DN123,PAPN,PAPN,TEST,918945,

想要转换为

"2016-07-30 00:00:00",DN123,PAPN,PAPN,TEST,918945,

Answer 1

假设您的文件名为 A.csv

使用以下内容:

awk -F","  '{print "\""substr($1,08,4)"-"substr($1,5,2)"-"substr($1,2,2)substr($1,12,9)"\","$2","$3","$4","$5","$6","}' A.csv > A.csv_new

然后您可以用旧文件替换新文件

mv A.csv_new A.csv