Wiki

User Tools

Site Tools

Trace: • x-mailer • virtual_host_debug • io_accounting_fields • count_lines_in_a_file • content_html_entities • check_promiscuous • aggregation_functions • apache_tuning_tips • active_vs_passive_ftp
awk:begin_and_end

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
awk:begin_and_end [2021/01/06 15:10] – peterawk:begin_and_end [2022/06/13 09:40] (current) – peter
Line 13: Line 13:
 <file> <file>
 10   Peter     Terence   Roux        45 10   Peter     Terence   Roux        45
-11   Virginia  Genevive  Roux        45+11   Virginia  Genevieve  Roux       45
 12   Felix     Devon     Roux         5 12   Felix     Devon     Roux         5
 13   David     Bruce     Stevenson   48 13   David     Bruce     Stevenson   48
Line 30: Line 30:
 </code> </code>
  
-which will display something like:+returns:
  
 <code> <code>
 NUMBER   ITEM   QUANTITY   PRICE NUMBER   ITEM   QUANTITY   PRICE
 </code> </code>
 +
 +----
  
 This would be more useful when run as: This would be more useful when run as:
Line 42: Line 44:
 </code> </code>
  
-which will display something like:+returns:
  
 <code> <code>
-NUMBER   ITEM    QUANTITY   PRICE +NUMBER ITEM QUANTITY PRICE 
-1 pens 10 1.99 +1 10 Peter Terence 
-2 pencils 20 3.99 +2 11 Virginia Genevieve 
-3 staplers 5 8.99 +3 12 Felix Devon 
-4 rulers 12 2.50+4 13 David Bruce 
 +5 14 Bob James 
 +6 48 Adam Winter
 </code> </code>
 +
 +<WRAP info>
 +**NOTE:**  
  
   * The **BEGIN** has allowed the header to be added to the output.   * The **BEGIN** has allowed the header to be added to the output.
   * The **NR** variable used in the 2nd print numbers each line.  It is a built-in variable of AWK.   * The **NR** variable used in the 2nd print numbers each line.  It is a built-in variable of AWK.
 +
 +</WRAP>
  
 ---- ----
Line 59: Line 68:
  
 ===== Basic END Statement ===== ===== Basic END Statement =====
 +
 +Assuming a file, **test2.txt**, exists with the following contents:
 +
 +<file>
 +pens      10    1.99
 +pencils   20    3.99
 +staplers   5    8.99
 +rulers    12    2.50
 +</file>
  
 Issue the following command: Issue the following command:
  
 <code awk> <code awk>
-awk '{x=x+($2*$3)} END {print "Total Value of Inventory: "x}' test.txt+awk '{x=x+($2*$3)} END {print "Total Value of Inventory: "x}' test2.txt
 </code> </code>
  
-which will display something like:+returns:
  
 <code> <code>
 Total Value of Inventory: 174.65 Total Value of Inventory: 174.65
 </code> </code>
 +
 +----
  
 This would be more useful when run as: This would be more useful when run as:
  
 <code awk> <code awk>
-awk '{x=x+($2*$3)} {print $1,"QTY: "$2,"PRICE:"$3,"TOTAL: "$2*$3} END {print "Total Value of Inventory: " x}' test.txt+awk '{x=x+($2*$3)} {print $1,"QTY: "$2,"PRICE:"$3,"TOTAL: "$2*$3} END {print "Total Value of Inventory: " x}' test2.txt
 </code> </code>
  
-which will display something like:+returns:
  
 <code> <code>
Line 87: Line 107:
 Total Value of Inventory: 174.65 Total Value of Inventory: 174.65
 </code> </code>
 +
 +<WRAP info>
 +**NOTE:**  
  
   * The **END** has allowed a total line to be added to the output.   * The **END** has allowed a total line to be added to the output.
       * It is only run at the end.       * It is only run at the end.
 +
 +</WRAP>
  
 ---- ----
  
  
awk/begin_and_end.1609945827.txt.gz · Last modified: 2021/01/06 15:10 by peter
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki