
平台论坛博客文库

› 论坛 › 程序设计 › Shell › awk数据处理

[文本处理] awk数据处理 [复制链接]

csccyab

小富即安

论坛徽章:: 0

1楼 [报告]

发表于 2018-09-20 16:57 |显示全部楼层

bash-4.2$ cat file
"SDESC","channel","catg","JUL16","AUG16","SEP16"
"销售额","全国","纸尿裤",26965.0,25948.2,26332.0
bash-4.2$
bash-4.2$
bash-4.2$ awk -F, '/SDESC/ {for (i=4; i<=NF; i++){date[i]=$4;} print $1,$2,$3,"\"date\"","\"sales\""} !/SDESC/ { for (i=4; i<=NF; i++){print $1,$2,$3,date[i],$i}}' file
"SDESC" "channel" "catg" "date" "sales"
"销售额" "全国" "纸尿裤" "JUL16" 26965.0
"销售额" "全国" "纸尿裤" "JUL16" 25948.2
"销售额" "全国" "纸尿裤" "JUL16" 26332.0

csccyab

小富即安

论坛徽章:: 0

2楼 [报告]

发表于 2018-09-20 17:02 |显示全部楼层

Sorry, this should be correct

bash-4.2$ awk -F, '/SDESC/ {for (i=4; i<=NF; i++){date[i]=$i;} print $1,$2,$3,"\"date\"","\"sales\""} !/SDESC/ { for (i=4; i<=NF; i++){print $1,$2,$3,date[i],$i}}' file
"SDESC" "channel" "catg" "date" "sales"
"销售额" "全国" "纸尿裤" "JUL16" 26965.0
"销售额" "全国" "纸尿裤" "AUG16" 25948.2
"销售额" "全国" "纸尿裤" "SEP16" 26332.0

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

返回列表

Chinaunix › 论坛 › 程序设计 › Shell › awk数据处理