awk将txt转换为csv

从mysql的表中导出来的txt数据格式：（mysql -e "select * from table_name;"）

[[email protected] ~]$ head choushu.log

1    13    56154    49817    ChargeMain_Shortcut    56154    0.33    1302    0.00863122    0.33863122    2018-09-18
2    7    1169    1066    ChargeMain_Shortcut    56154    0.00687561    39    0.01237113    0.01924674    2018-09-18
3    12    5016    4476    ChargeMain_Shortcut    56154    0.02948286    185    0.01371007    0.04319293    2018-09-18
4    10    781    720    ChargeMain_Shortcut    56154    0.00459549    24    0.01144244    0.01603793    2018-09-18
5    9    1331    1198    ChargeMain_Shortcut    56154    0.00782762    40    0.0112844    0.01911202    2018-09-18
6    14    6394    5262    ChargeMain_Shortcut    56154    0.0375808    196    0.01235227    0.04993307    2018-09-18
7    5    4111    3615    ChargeMain_Shortcut    56154    0.02416454    97    0.00894358    0.03310812    2018-09-18
8    6    1336    1107    ChargeMain_Shortcut    56154    0.007857    164    0.0491426    0.0569996    2018-09-18

需要转换为csv格式

第一种方法就是通过excel，导入，然后固定宽度的方式保存

有个缺点就是当表特别大的时候，可能会卡主；而且不方便实现自动化；

我们现在用awk工具实现；

mysql -h address -P port -D database -u username -ppassword -e 
"select * from tb_name;" | awk '{for(i=1;i<=NF;i++) {if(i<11) printf $i",";else print $i}}' > choushu.csv

结果：

1,13,56154,49817,ChargeMain_Shortcut,56154,0.33,1302,0.00863122,0.33863122,2018-09-18
2,7,1169,1066,ChargeMain_Shortcut,56154,0.00687561,39,0.01237113,0.01924674,2018-09-18
3,12,5016,4476,ChargeMain_Shortcut,56154,0.02948286,185,0.01371007,0.04319293,2018-09-18
4,10,781,720,ChargeMain_Shortcut,56154,0.00459549,24,0.01144244,0.01603793,2018-09-18
5,9,1331,1198,ChargeMain_Shortcut,56154,0.00782762,40,0.0112844,0.01911202,2018-09-18
6,14,6394,5262,ChargeMain_Shortcut,56154,0.0375808,196,0.01235227,0.04993307,2018-09-18
7,5,4111,3615,ChargeMain_Shortcut,56154,0.02416454,97,0.00894358,0.03310812,2018-09-18

直接双击打开