📄 ch49_07.htm
字号:
<HTML><!--Distributed by F --><HEAD><TITLE>[Chapter 49] 49.7 Total a Column with addup </TITLE><METANAME="DC.title"CONTENT="UNIX Power Tools"><METANAME="DC.creator"CONTENT="Jerry Peek, Tim O'Reilly & Mike Loukides"><METANAME="DC.publisher"CONTENT="O'Reilly & Associates, Inc."><METANAME="DC.date"CONTENT="1998-08-04T21:56:41Z"><METANAME="DC.type"CONTENT="Text.Monograph"><METANAME="DC.format"CONTENT="text/html"SCHEME="MIME"><METANAME="DC.source"CONTENT="1-56592-260-3"SCHEME="ISBN"><METANAME="DC.language"CONTENT="en-US"><METANAME="generator"CONTENT="Jade 1.1/O'Reilly DocBook 3.0 to HTML 4.0"><LINKREV="made"HREF="mailto:online-books@oreilly.com"TITLE="Online Books Comments"><LINKREL="up"HREF="ch49_01.htm"TITLE="49. Working with Numbers"><LINKREL="prev"HREF="ch49_06.htm"TITLE="49.6 Quick Arithmetic with expr "><LINKREL="next"HREF="ch49_08.htm"TITLE="49.8 It's Great to Have a Spreadsheet "></HEAD><BODYBGCOLOR="#FFFFFF"TEXT="#000000"><DIVCLASS="htmlnav"><H1><IMGSRC="gifs/smbanner.gif"ALT="UNIX Power Tools"USEMAP="#srchmap"BORDER="0"></H1><MAPNAME="srchmap"><AREASHAPE="RECT"COORDS="0,0,466,58"HREF="index.htm"ALT="UNIX Power Tools"><AREASHAPE="RECT"COORDS="467,0,514,18"HREF="jobjects/fsearch.htm"ALT="Search this book"></MAP><TABLEWIDTH="515"BORDER="0"CELLSPACING="0"CELLPADDING="0"><TR><TDALIGN="LEFT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_06.htm"TITLE="49.6 Quick Arithmetic with expr "><IMGSRC="gifs/txtpreva.gif"SRC="gifs/txtpreva.gif"ALT="Previous: 49.6 Quick Arithmetic with expr "BORDER="0"></A></TD><TDALIGN="CENTER"VALIGN="TOP"WIDTH="171"><B><FONTFACE="ARIEL,HELVETICA,HELV,SANSERIF"SIZE="-1">Chapter 49<BR>Working with Numbers</FONT></B></TD><TDALIGN="RIGHT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_08.htm"TITLE="49.8 It's Great to Have a Spreadsheet "><IMGSRC="gifs/txtnexta.gif"SRC="gifs/txtnexta.gif"ALT="Next: 49.8 It's Great to Have a Spreadsheet "BORDER="0"></A></TD></TR></TABLE> <HRALIGN="LEFT"WIDTH="515"TITLE="footer"></DIV><DIVCLASS="SECT1"><H2CLASS="sect1"><ACLASS="title"NAME="UPT-ART-4180">49.7 Total a Column with addup </A></H2><TABLECLASS="para.programreference"BORDER="1"><TR><THVALIGN="TOP"><ACLASS="programreference"HREF="examples/index.htm"TITLE="addup">addup</A><BR></TH><TDVALIGN="TOP"><ACLASS="indexterm"NAME="AUTOID-58709"></A><ACLASS="indexterm"NAME="AUTOID-58711"></A><ACLASS="indexterm"NAME="AUTOID-58714"></A><ACLASS="indexterm"NAME="AUTOID-58717"></A><ACLASS="indexterm"NAME="AUTOID-58720"></A>Some programs output information in columns.The <EMCLASS="emphasis">addup</EM> script totals the numbers in a column.It reads from files or standard input.For example,the <EMCLASS="emphasis">lastcomm</EM> command shows CPU time used in column 4, like this:</TD></TR></TABLE><PCLASS="para"><BLOCKQUOTECLASS="screen"><PRECLASS="screen">% <CODECLASS="userinput"><B>lastcomm tcomm</B></CODE>sleep tcomm __ 0.08 secs Thu Mar 27 10:23date tcomm __ 0.08 secs Thu Mar 27 10:23tail tcomm __ 0.09 secs Thu Mar 27 10:23pwho tcomm __ 0.30 secs Thu Mar 27 10:23% <CODECLASS="userinput"><B>lastcomm tcomm | addup 4</B></CODE>0.550000</PRE></BLOCKQUOTE></P><PCLASS="para"><ACLASS="indexterm"NAME="AUTOID-58731"></A><ACLASS="indexterm"NAME="AUTOID-58734"></A><ACLASS="indexterm"NAME="AUTOID-58737"></A><ACLASS="indexterm"NAME="AUTOID-58740"></A><ACLASS="indexterm"NAME="AUTOID-58743"></A><ACLASS="indexterm"NAME="AUTOID-58746"></A><SPANCLASS="link"><EMCLASS="emphasis">grep -c</EM> (<ACLASS="linkend"HREF="ch15_08.htm"TITLE="Getting a List of Non-Matching Files with grep -c ">15.8</A>)</SPAN>outputs the number of matches after a colon (<CODECLASS="literal">:</CODE>) on each line.To total the matches, pipe <EMCLASS="emphasis">grep</EM>'s output through alittle <EMCLASS="emphasis">sed</EM> command to strip off the filenames and colon;have <EMCLASS="emphasis">addup</EM> sum the output (the "first column"):</P><PCLASS="para"><BLOCKQUOTECLASS="screen"><PRECLASS="screen">% <CODECLASS="userinput"><B>grep -c CAUTION *.txt</B></CODE>abar.txt:0applic.txt:3badprob.txt:235 ...% <CODECLASS="userinput"><B>grep -c CAUTION *.txt | sed 's/.*://' | addup 1</B></CODE>317</PRE></BLOCKQUOTE></P><PCLASS="para">Here's the script:</P><PCLASS="para"><BLOCKQUOTECLASS="screen"><PRECLASS="screen">case "$1" in[1-9]*) colnum="$1"; shift;;*) echo "Usage: `basename $0` colnum [files]" 1>&2; exit 1;;esac# Use integer output, but switch to %.4f format if "." in input.awk '{sum += $col}END {print sum}' col=$colnum OFMT='%.4f' ${1+"$@"}</PRE></BLOCKQUOTE></P><PCLASS="para"><ACLASS="indexterm"NAME="AUTOID-58763"></A><ACLASS="indexterm"NAME="AUTOID-58766"></A>The <CODECLASS="literal">${1+"$@"}</CODE> holds filenames (if any) from the command line andworks around a<SPANCLASS="link">shell quoting problem (<ACLASS="linkend"HREF="ch46_07.htm"TITLE="Quoting and Command-Line Parameters ">46.7</A>)</SPAN>.The <EMCLASS="emphasis">awk</EM> script passes in the column through a variable on itscommand line, then <CODECLASS="literal">$col</CODE> becomes the column number.The script defaults to integer output format, without a decimal point.If it sees a "." in the input (like <CODECLASS="literal">1.5</CODE>),it switches to floating-point output format; the <EMCLASS="emphasis">OFMT</EM> variablesetting of <CODECLASS="literal">%.4f</CODE> forces <EMCLASS="emphasis">awk</EM> to always print the resultwith four digits after the decimal point.(The default <EMCLASS="emphasis">OFMT</EM> setting, <CODECLASS="literal">%.6g</CODE>, prints large numbers ine-notation.If you want that, delete the <CODECLASS="literal">OFMT='%.4f'</CODE>.)</P><DIVCLASS="sect1info"><PCLASS="SECT1INFO">- <SPANCLASS="authorinitials">JP</SPAN></P></DIV></DIV><DIVCLASS="htmlnav"><P></P><HRALIGN="LEFT"WIDTH="515"TITLE="footer"><TABLEWIDTH="515"BORDER="0"CELLSPACING="0"CELLPADDING="0"><TR><TDALIGN="LEFT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_06.htm"TITLE="49.6 Quick Arithmetic with expr "><IMGSRC="gifs/txtpreva.gif"SRC="gifs/txtpreva.gif"ALT="Previous: 49.6 Quick Arithmetic with expr "BORDER="0"></A></TD><TDALIGN="CENTER"VALIGN="TOP"WIDTH="171"><ACLASS="book"HREF="index.htm"TITLE="UNIX Power Tools"><IMGSRC="gifs/txthome.gif"SRC="gifs/txthome.gif"ALT="UNIX Power Tools"BORDER="0"></A></TD><TDALIGN="RIGHT"VALIGN="TOP"WIDTH="172"><ACLASS="SECT1"HREF="ch49_08.htm"TITLE="49.8 It's Great to Have a Spreadsheet "><IMGSRC="gifs/txtnexta.gif"SRC="gifs/txtnexta.gif"ALT="Next: 49.8 It's Great to Have a Spreadsheet "BORDER="0"></A></TD></TR><TR><TDALIGN="LEFT"VALIGN="TOP"WIDTH="172">49.6 Quick Arithmetic with expr </TD><TDALIGN="CENTER"VALIGN="TOP"WIDTH="171"><ACLASS="index"HREF="index/idx_0.htm"TITLE="Book Index"><IMGSRC="gifs/index.gif"SRC="gifs/index.gif"ALT="Book Index"BORDER="0"></A></TD><TDALIGN="RIGHT"VALIGN="TOP"WIDTH="172">49.8 It's Great to Have a Spreadsheet </TD></TR></TABLE><HRALIGN="LEFT"WIDTH="515"TITLE="footer"><IMGSRC="gifs/smnavbar.gif"SRC="gifs/smnavbar.gif"USEMAP="#map"BORDER="0"ALT="The UNIX CD Bookshelf Navigation"><MAPNAME="map"><AREASHAPE="RECT"COORDS="0,0,73,21"HREF="../index.htm"ALT="The UNIX CD Bookshelf"><AREASHAPE="RECT"COORDS="74,0,163,21"HREF="index.htm"ALT="UNIX Power Tools"><AREASHAPE="RECT"COORDS="164,0,257,21"HREF="../unixnut/index.htm"ALT="UNIX in a Nutshell"><AREASHAPE="RECT"COORDS="258,0,321,21"HREF="../vi/index.htm"ALT="Learning the vi Editor"><AREASHAPE="RECT"COORDS="322,0,378,21"HREF="../sedawk/index.htm"ALT="sed & awk"><AREASHAPE="RECT"COORDS="379,0,438,21"HREF="../ksh/index.htm"ALT="Learning the Korn Shell"><AREASHAPE="RECT"COORDS="439,0,514,21"HREF="../lrnunix/index.htm"ALT="Learning the UNIX Operating System"></MAP></DIV></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -