Differences

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

--- awk:begin_and_end [2020/05/06 20:02] – peter
+++ awk:begin_and_end [2022/06/13 09:40] (current) – peter
@@ Line 6: / Line 6: @@
   * **END** statements, on the other hand, can be used to continue processing after the program has finished.
+----
+Assuming a file, **test.txt**, exists with the following contents:
+<file>
+   Peter     Terence   Roux        45
+   Virginia  Genevieve  Roux       45
+   Felix     Devon     Roux         5
+   David     Bruce     Stevenson   48
+   Bob       James     Smith       16
+   Adam      Winter    Ridley      23
+</file>
 ----
@@ Line 14: / Line 27: @@
 <code awk>
-awk 'BEGIN {print "NUMBER ITEM QUANTITY PRICE"}' /sharewiz/awk/test2.txt
+awk 'BEGIN {print "NUMBER ITEM QUANTITY PRICE"}' test.txt
 </code>
-which will display something like:
+returns:
 <code>
 NUMBER   ITEM   QUANTITY   PRICE
 </code>
+----
 This would be more useful when run as:
 <code awk>
-awk 'BEGIN {print "NUMBER ITEM QUANTITY PRICE"}{print NR,$1,$2,$3}' /sharewiz/awk/test2.txt
+awk 'BEGIN {print "NUMBER ITEM QUANTITY PRICE"}{print NR,$1,$2,$3}' test.txt
 </code>
-which will display something like:
+returns:
 <code>
-NUMBER   ITEM    QUANTITY   PRICE
+NUMBER ITEM QUANTITY PRICE
- pens 10 1.99
+10 Peter Terence
- pencils 20 3.99
+ 11 Virginia Genevieve
-staplers 5 8.99
+ 12 Felix Devon
-rulers 12 2.50
+13 David Bruce
+ 14 Bob James
+48 Adam Winter
 </code>
+<WRAP info>
+**NOTE:**
   * 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.
+</WRAP>
 ----
@@ Line 46: / Line 68: @@
 ===== 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:
 <code awk>
-awk '{x=x+($2*$3)} END {print "Total Value of Inventory: "x}' /sharewiz/awk/test2.txt
+awk '{x=x+($2*$3)} END {print "Total Value of Inventory: "x}' test2.txt
 </code>
-which will display something like:
+returns:
 <code>
 Total Value of Inventory: 174.65
 </code>
+----
 This would be more useful when run as:
 <code awk>
-awk '{x=x+($2*$3)} {print $1,"QTY: "$2,"PRICE:"$3,"TOTAL: "$2*$3} END {print "Total Value of Inventory: " x}' /sharewiz/awk/test2.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>
-which will display something like:
+returns:
 <code>
@@ Line 74: / Line 107: @@
 Total Value of Inventory: 174.65
 </code>
+<WRAP info>
+**NOTE:**
   * The **END** has allowed a total line to be added to the output.
       * It is only run at the end.
+</WRAP>
 ----