awk处理数据

小灰灰 2022-11-21 04:19 196阅读 0赞

# awk处理数据 #

### 原始数据 ###

*  文件名test.txt
 *  说明
    
     *  文本数据量形如下面的数据，数据量多的情况下excel不方便处理
     *  主要目的是通过第四列【手机号（0~9）】尾号将一个txt文件拆分为10个文件

L3020072600409325|BMAY1617|60100965888885|15035688731|1|20200801000000|20991231235959|heal02|20200726104846|20200726104846|2|20200801000000
    L3020072200926044|BMAY1617|60100963277362|13834588453|1|20200801000000|20991231235959|aggsvD|20200722183930|20200722183930|2|20200801000000

### 核心处理语句 ###

*  cat test.txt |awk -F '|' -va='|' '$4%10==0 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_0.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==1 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_1.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==2 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_2.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==3 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_3.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==4 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_4.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==5 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_5.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==6 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_6.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==7 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_7.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==8 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_8.txt
 *  cat test.txt |awk -F '|' -va='|' '$4%10==9 \{print $1a$2a$3a$4a$5a$6a$7a$8a$9a$10a$11a$12\}' >>order\_9.txt

### 命令解析 ###

*  ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2VpZWllaTQzOA_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2VpZWllaTQzOA_size_16_color_FFFFFF_t_70]: /images/20221120/a946ed64e60d44b196a7b234dd368df4.png