• 企业400电话
  • 微网小程序
  • AI电话机器人
  • 电商代运营
  • 全 部 栏 目

    企业400电话 网络优化推广 AI电话机器人 呼叫中心 网站建设 商标✡知产 微网小程序 电商运营 彩铃•短信 增值拓展业务
    linux awk高级应用实例

    今天看到unix shell 范例精解上有道awk的题目 做了以后拿来和大家分享下

    处理前的文档:

     Mike Harrington:(510) 548-1278:250:100:175
     Christian Dobbins:(408) 538-2358:155:90:201
     Susan Dalsass:(206) 654-6279:250:60:50
     Archie McNichol:(206) 548-1348:250:100:175
     Jody Savage:(206) 548-1278:15:188:150
     Guy Quigley:(916) 343-6410:250:100:175
     Dan Savage:(406) 298-7744:450:300:275
     Nancy McNeil:(206) 548-1278:250:80:75
     John Goldenrod:(916) 348-4278:250:100:175
     Chet Main:(510) 548-5258:50:95:135
     Tom Savage:(408) 926-3456:250:168:200
     Elizabeth Stachelin:(916) 440-1763:175:75:300

    需要的结果如下:
                    ***CAMPAIGN 1998 CONTRIBUTIONS***

    Name                   PHone                   Jan |   Feb |   MAR |   Total Donated
    ---------------------------------------------------------------------------------
     
    Mike Harrington         (510) 548-1278          250     100     175     525
    Christian Dobbs         (408) 538-2358          155     90      201     446
    Susan Dalsass           (206) 654-6279          250     60      50      360
    Archie McNichol         (206) 548-1348          250     100     175     525
    Jody Savage             (206) 548-1278          15      188     150     353
    Guy Quigley             (916) 343-6410          250     100     175     525
    Dan Savage              (406) 298-7744          450     300     275     1025
    Nancy McNeil            (206) 548-1278          250     80      75      405
    John Goldenrod          (916) 348-4278          250     100     175     525
    Chet Main               (510) 548-5258          50      95      135     280
    Tom Savage              (408) 926-3456          250     168     200     618
    Elibeth Stachel         (916) 440-1763          175     75      300     550

     SUMMARY
    -----------------------------------------------------------------------------------
    The campan received atotal of $6137 for this quarter
    average donation for the 12 contributors was $511.417.
    The highest contribution was $450.
    The lowest contribution was $15.

    代码如下:

    BEGIN{FS=":";low1=300;low2=400;low3=500
        OFS="\t"
        print "\t\t***CAMPAIGN 1998 CONTRIBUTIONS***\n"
        print "---------------------------------------------------------------------------------\n"
        print " Name\t\t\tPHone\t\t\tJan |\tFeb |\tMAR |\tTotal Donated"
        print "---------------------------------------------------------------------------------\n"
        }
     
    {tot=$3+$4+$5}
    {Ttot+=tot}
    {print $1,"\t"$2"\t\t"$3" \t"$4" \t"$5" \t"tot}
    {avg=Ttot/12}
    {high1=(high1>$3)?high1:$3}
    {high2=(high1>$4)?high1:$4}
    {high3=(high1>$5)?high1:$5}
    {max12=(high1>high2)?high1:high2}
    {max23=(high2>high3)?high2:high3}
    {Max=(max12>max23)?max12:max23}
    {low1=(low1$3)?low1:$3}
    {low2=(low1$4)?low1:$4}
    {low3=(low1$5)?low1:$5}
    {min12=(low1low2)?low1:low2}
    {min23=(low2low3)?low2:low3}
    {Min=(min12min23)?min12:min23}
     
    END{
        print "-----------------------------------------------------------------------------------"
        print"\t\tSUMMARY"
        print "-----------------------------------------------------------------------------------"
        printf "The campan received atotal of $";printf Ttot; print " for this quarter"
        printf "average donation for the 12 contributors was $"; printf avg ;print"."
        printf "The highest contribution was $";printf Max;print "."
        printf "The lowest contribution was $";printf Min;print "." 
    }
    您可能感兴趣的文章:
    • Linux里awk中split函数的用法小结
    • linux正则表达式awk详解
    • 一天一个shell命令 linux文本内容操作系列-awk命令详解
    • Linux中 sed 和 awk的用法详解
    • linux awk时间计算脚本及awk命令详解
    • linux shell awk获得外部变量(变量传值)简介
    • linux之awk命令的用法
    • Linux awk将文件某列按照逗号分隔的例子
    • Linux中awk的使用方法详解
    上一篇:linux shell实现求一个多维数组中的最大和最小值
    下一篇:linux下2个检查tcp连接的命令
  • 相关文章
  • 

    © 2016-2020 巨人网络通讯 版权所有

    《增值电信业务经营许可证》 苏ICP备15040257号-8

    linux awk高级应用实例 linux,awk,高级,应用,实例,