AWK使用示例

Linux的awk命令处理文本的功能真的很强大。

处理文本中的身份证号： 

第10列的内容是身份证号
cat ./compare_result.txt | awk -F ',' '{if (length($10)==18){print $1","$2","$3","$4","$5","$6","$7","$8","$9","substr($10,1,14)"****,"$11","$12","$13","$14} else {print $0}}' > compare_result_OK.txt 

处理文本中的手机号： 

第7列提示第8列为手机号
cat ./compare_result_OK.txt | awk -F ',' '{if ($7=="cell_phone_no"){print $1","$2","$3","$4","$5","$6","$7","substr($8,1,25)"**,"substr($9,1,19)"**,"$10","$11","$12","$13","$14} else {print $0}}' > compare_result_OK2.txt