View source for Tutorial11: Sed & Awk Utilities

=USING SED &amp; AWK UTILTIES=
<br>
===Main Objectives of this Practice Tutorial===

:* Use the '''sed''' command to '''manipulate text''' contained in a file.

:* List and understand several '''instructions''' associated with the '''sed''' command.

:* Use the '''sed''' command as a '''filter''' with Linux pipeline commands.

:* Use the '''awk''' command to '''manipulate text''' contained in a file.

:* Use the '''awk''' command as a '''filter''' with Linux pipeline commands.
<br><br>
===Tutorial Reference Material===

{|width="100%" cellspacing="0" cellpadding="10"

|- valign="top"

|colspan="2" style="font-size:16px;font-weight:bold;border-bottom: thin solid black;border-spacing:0px;"|Course Notes<br>

|colspan="2" style="font-size:16px;font-weight:bold;border-bottom: thin solid black;border-spacing:0px;padding-left:15px;"|Linux Command/Shortcut Reference<br>

|colspan="1" style="font-size:16px;font-weight:bold;border-bottom: thin solid black;border-spacing:0px;padding-left:15px;"|YouTube Videos<br>

|- valign="top" style="padding-left:15px;"

|colspan="2" |Course Notes:<ul><li>[https://ict.senecacollege.ca/~murray.saul/uli101/ULI101-Week11.pdf PDF] | [https://ict.senecacollege.ca/~murray.saul/uli101/ULI101-Week11.pptx PPTX]</li></ul>


|  style="padding-left:15px;" |Text Manipulation
* [https://www.digitalocean.com/community/tutorials/the-basics-of-using-the-sed-stream-editor-to-manipulate-text-in-linux Purpose of using sed utility]
* [https://www.digitalocean.com/community/tutorials/how-to-use-the-awk-language-to-manipulate-text-in-linux Purpose of using awk utility]

|  style="padding-left:15px;" |Man Pages
* [https://man7.org/linux/man-pages/man1/sed.1p.html sed]
* [https://man7.org/linux/man-pages/man1/awk.1p.html awk]


|colspan="1" style="padding-left:15px;" width="30%"|Brauer Instructional Videos:<ul><li>[https://www.youtube.com/watch?v=npU6S61AIko&list=PLU1b1f-2Oe90TuYfifnWulINjMv_Wr16N&index=14 Using the sed Utility]</li><li>[https://www.youtube.com/watch?v=OV3XzjDYgJo&list=PLU1b1f-2Oe90TuYfifnWulINjMv_Wr16N&index=13 Using the awk Utility]</ul>
|}

= KEY CONCEPTS =


===Using the sed Utility===


'''Usage:'''

'''<span style="color:blue;font-weight:bold;font-family:courier;">Syntax:  sed [-n] 'address instruction' filename</span>''' 


'''Notes:'''

*The sed command reads '''all lines in the input file''' and will be exposed to the expression (contained in quotes).
* If the line matches the '''address''', then it will perform the '''instruction'''.

'''Address:'''

*can use a '''line number''', to select a specific line 
*can specify a '''range of line numbers''' 
*can specify a '''regular expression''' to select all lines that match
*'''Note:''' when using regular expressions, you must delimit them with a<br>'''forward-slash''' "'''/'''" default address (if none is specified) will match every line

[[Image:sed.png|thumb|right|500px|'''Common instructions''' to take action if text matches an address.]]
'''Instruction:'''
*'''Action''' to take for matched line(s)
*Refer to table on right-side for list of some '''common instructions'''<br>and their purpose


'''Examples:'''

<span style="font-family:courier;">'''sed -n '3 p' text.txt'''   (print 3rd line)<br>'''sed -n '1-5 p' text.txt''' (print lines 1 to 5)<br>'''sed -n '4,7 p' text.txt''' (print only lines 4 and 7)<br>'''sed -n'/^Therefore/ p' text.txt''' (print lines that begin with the patterh "Therefore")<br><br>'''sed '/^#/ d' myscript.bash''' (remove comments at beginning of line)<br>'''sed '/exit/ q' text.txt''' (print all lines until line containing pattern: "exit")<br>'''sed 's/this/that/' text.txt''' (replace first occurrence of pattern "this" with "that")<br>'''sed 's/this/that/' text.txt''' (replace ALL occurrences of pattern "this" with "that")<br><br></span>

===Using the awk Utility===
 

'''Usage:'''

<span style="color:blue;font-weight:bold;font-family:courier;">awk options 'selection _criteria {action }’ file-name</span>


'''Notes:'''

*The awk command reads '''all lines in the input file''' and will be exposed to the expression (contained within quotes) for processing.
*Expression (contained in quotes) represents selection criteria, and action to execute (contained within braces) if selection criteria is matched 
*If no pattern is specified, awk selects all lines in the input
*If no action is specified, awk copies the selected lines to standard output


'''Patterns: Regular Expressions'''

*You can use a '''regular expression''', enclosed within slashes, as a pattern. 
*The '''~''' operator tests whether a field or variable matches a regular expression 
*The '''!~''' operator tests for no match.
*You can perform both numeric and string comparisons using relational operators 
*You can combine any of the patterns using the Boolean operators '''||''' (OR) and '''&&''' (AND)
*You can use '''built-in variables''' (like '''NR''' or "record number" representing line number) with comparison operators


[[Image:awk.png|thumb|right|300px|'''Comparison operators''' used with the '''awk''' command.]]
'''Patterns: Relational Operators'''

*The following operators (in the table on the right-side) can be used with the awk utility to pattern searching. 
*Since those symbols are used within the expression, they are NOT confused with redirection symbols.


'''Examples:'''

<span style="font-family:courier;">'''awk 'NR == 3 {print}' text.txt'''   (print 3rd line)<br>'''x''' (x)<br>'''x''' (x)<br>'''x''' (x)<br><br>'''x''' (x)<br>'''x''' (x)<br>'''x''' (x)<br>'''x''' (x)<br><br></span>

=INVESTIGATION 1: USING THE SED UTILITY=

<br>
In this section, you will learn how to manipulate text using the '''sed''' utility.


'''Perform the Following Steps:'''

# '''Login''' to your matrix account.<br><br>
# Issue a command to '''confirm''' you are located in your home directory.<br><br>
# Issue the following linux command ('''copy and paste''' to save time):<br><span style="color:blue;font-weight:bold;font-family:courier;">wget <nowiki>https://ict.senecacollege.ca/~murray.saul/uli101/data.txt</nowiki></span><br><br>
# Issue the '''more''' command to quickly view the contents of the '''data.txt''' file.<br>When finished, exit the more command by pressing the letter <span style="color:blue;font-weight:bold;font-family:courier;">q</span><br><br>
# The '''p''' command in sed is used to print or display the contents of a text file.<br>Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed 'p' data.txt</span><br><br>You should notice that each line appears twice. The reason why standard output appears twice is that the sed command (without the -n option) displays all lines regardless if they had been specified as a pattern.<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed -n 'p' data.txt</span><br><br>What do you notice?<br><br>You can specify an address (line #, line #s or range of line #s) when using the sed utility.<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed -n '1 p' data.txt</span><br><br>You should see the first line of the text file displayed.<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed -n '2,5 p' data.txt</span><br><br>What do you think is displayed? (in another SSH session, compare with contents in the data.txt text file to confirm).<br><br>The '''s''' command is used to substitute patterns (similar to method demonstratedin vi editor).<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed '2,5 s/TUTORIAL/LESSON/g' data.txt</span><br><br>What do you notice? View the original contents of lines 2 to 5 in the '''data.txt''' file in another shell to confirm that the substitution occurred.<br><br>The '''q''' command terminates or quits the execution of the sed utility as soon as it read in a particular line or matching pattern.<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed '11 q' data.txt</span><br><br>What did you notice?<br><br>You can use regular expressions to select lines that match a pattern. The rules remain the same for using regular expressions as demonstrated in lab8 except the regular expression must be contained within delimiters such as the forward slash "/" when using the sed utility.<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed -n '/^The/ p' data.txt</span><br><br>What do you notice?<br><br>
# Issue the following linux command:<br><span style="color:blue;font-weight:bold;font-family:courier;">sed -n '/d$/ p' data.txt</span><br><br>What do you notice?<br><br>The '''sed''' utility can also be used as a filter to manipulate text that was generated from linux commands.<br><br>
# Issue the following linux pipeline command:<br><span style="color:blue;font-weight:bold;font-family:courier;">ls | sed -n '/txt$/ p'</span><br><br>What did you notice?<br><br>
# Issue the following linux pipeline command:<br><span style="color:blue;font-weight:bold;font-family:courier;">who | sed -n '/^[a-m]/ p' | more</span><br><br>What did you notice?<br><br>

:In the next investigation, you will learn how to manipulate text using the awk utility.<br><br>

=INVESTIGATION 2: USING THE AWK UTILITY =

In this section, you will learn how to use the awk utility to manipulate text and generate reports.


'''Perform the Following Steps:'''

# Issue a command to '''confirm''' you are located in your home directory.<br><br>
# Issue the following linux command ('''copy and paste''' to save time):<br><span style="color:blue;font-weight:bold;font-family:courier;">wget <nowiki>https://ict.senecacollege.ca/~murray.saul/uli101/cars.txt</nowiki></span><br><br>
# Issue the '''more''' command to quickly view the contents of the '''cars.txt''' file.<br>When finished, exit the more command by pressing the letter <span style="color:blue;font-weight:bold;font-family:courier;">q</span><br><br>The "print" action is the default action of awk to print all selected lines that match a pattern.<br>This action (contained in braces) can provide more options such as printing specific fields of selected lines (or records) from a database.<br><br>
# Issue the following linux command all to display records in the "cars.txt" database that contain the make "ford":<br><span style="color:blue;font-weight:bold;font-family:courier;">wget awk '/ford/ {print}' cars.txt</span><br><br>
# Issue the following linux command all to display records in the "cars.txt" database that contain the make "ford":<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '/ford/' cars.txt</span><br><br>What do you notice?<br><br>You can use variables with the "print" action for further processing. We will discuss the following variables in this tutorial:<br><br>'''$0''' - Current record (entire line)<br>'''$1''' - First field in record<br>'''$n''' - nth field in record<br>'''NR''' - Record Number (order in database)<br>	'''NF''' - Number of fields in current record<br><br>For a listing of more variables, please consult your course notes.<br><br>The tilde '''~''' character is used to search for a pattern or display standard output for a particular field.<br><br>
# Issue the following linux command to display the model, year, quantity and price in the "cars.txt" database for makes of "chevy":<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '/chevy/ {print $2,$3,$4,$5}' cars.txt</span><br><br>Notice that a space " " is the delimiter for the fields that appear as standard output.<br><br>
# Issue the following linux command to display all plymouths (plyms) by model name, price and quantity:<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '/chevy/ {print $2,$3,$4,$5}' cars.txt</span><br><br>You can also use comparison operators to specify conditions for processing with matched patterns when using the awk command. Since they are used WITHIN the awk expression, they are not confused with redirection symbols<br><br>	Comparison Operators:<br><br>'''<'''	 &nbsp;&nbsp;&nbsp;&nbsp;Less than<br>'''<='''	&nbsp;&nbsp;Less than or equal<br>'''>'''	&nbsp;&nbsp;&nbsp;&nbsp;Greater than<br>'''>='''	&nbsp;&nbsp;Greater than or equal<br>'''=='''	&nbsp;&nbsp;Equal<br>'''!='''	&nbsp;&nbsp;&nbsp;Not equal<br><br>
# Issue the following linux command to display display the car make, model number, quantity and price of all vehicles that are prices less than $5,000:<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '$5 < 5000 {print $1,$2,$4,$5}' cars.txt</span><br><br>What do you notice?<br><br>
# Issue the following linux command to display display the car make, model number, quantity and price of all vehicles that are prices less than $5,000:<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '$5 < 5000 {print $1,$2,$4,$5}' cars.txt</span><br><br>The symbol tilde '''~''' is used to match a pattern for a particular field number.<br><br>
# Issue the following linux command to display the car make, year and quantity of all car makes that begin with the letter 'f':<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '$1 ~ /^f/ {print $1,$2,$4}' cars.txt</span><br><br>Compound criteria symbols can be used to join search statements together<br><br>Compound Operators:<br><br>'''&&''' &nbsp;&nbsp;&nbsp;&nbsp;(and)<br>'''||''' &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(or)<br><br>
# Issue the following linux command to list all "fords" that are greater than $10,000 in price:<br><span style="color:blue;font-weight:bold;font-family:courier;">awk '$1 ~ /ford/ && $5 > 10000 {print $0}' cars.txt</span><br><br>
# After you complete the Review Questions sections to get additional practice, then work on your '''online assignment 3,'''<br>'''sections 4 to 6''' labelled: '''More Scripting (add)''', '''Yet More Scripting (oldfiles)''', and '''sed And awk'''<br><br>

= LINUX PRACTICE QUESTIONS =

The purpose of this section is to obtain '''extra practice''' to help with '''quizzes''', your '''midterm''', and your '''final exam'''.

Here is a link to the MS Word Document of ALL of the questions displayed below but with extra room to answer on the document to
simulate a quiz:

https://ict.senecacollege.ca/~murray.saul/uli101/uli101_week11_practice.docx

Your instructor may take-up these questions during class. It is up to the student to attend classes in order to obtain the answers to the following questions. Your instructor will NOT provide these answers in any other form (eg. e-mail, etc).


'''Review Questions:'''

'''Part A: Display Results from Using the sed Utility'''

Note the contents from the following tab-delimited file called '''~murray.saul/uli101/stuff.txt''':
(this file pathname exists for checking your work)

<pre>
Line one.
This is the second line.
This is the third.
This is line four.
Five.
Line six follows
Followed by 7
Now line 8
and line nine
Finally, line 10
</pre>


Write the results of each of the following Linux commands for the above-mentioned file:


# sed -n '3,6 p' ~murray.saul/uli101/stuff.txt<br><br>
# sed '4 q' ~murray.saul/uli101/stuff.txt<br><br>
# sed '/the/ d' ~murray.saul/uli101/stuff.txt<br><br>
# sed 's/line/NUMBER/g' ~murray.saul/uli101/stuff.txt


'''Part B: Writing Linux Commands Using the sed Utility'''

Write a single Linux command to perform the specified tasks for each of the following questions.


# Write a Linux sed command to display only lines 5 to 9 for the file: '''~murray.saul/uli101/stuff.txt'''<br><br>
# Write a Linux sed command to display only lines the begin the pattern “and” for the file: '''~murray.saul/uli101/stuff.txt'''<br><br>
# Write a Linux sed command to display only lines that end with a digit for the file: '''~murray.saul/uli101/stuff.txt'''<br><br>
# Write a Linux sed command to save lines that match the pattern “line” (upper or lowercase) for the file: '''~murray.saul/uli101/stuff.txt''' and save results (overwriting previous contents) to: '''~/results.txt'''<br><br>


'''Part C: Writing Linux Commands Using the awk Utility'''

Note the contents from the following tab-delimited file called '''~murray.saul/uli101/stuff.txt''':
(this file pathname exists for checking your work)

<pre>
Line one.
This is the second line.
This is the third.
This is line four.
Five.
Line six follows
Followed by 7
Now line 8
and line nine
Finally, line 10
</pre>


'''Write the results of each of the following Linux commands for the above-mentioned file:'''


# awk ‘NR == 3 {print}’ ~murray.saul/uli101/stuff.txt<br><br>
# awk ‘NR >= 2 && NR <= 5 {print}’ ~murray.saul/uli101/stuff.txt<br><br>
# awk ‘$1 ~ /This/ {print $2}’ ~murray.saul/uli101/stuff.txt<br><br>
# awk ‘$1 ~ /This/ {print $3,$2}’ ~murray.saul/uli101/stuff.txt<br><br>


'''Part D: Writing Linux Commands Using the awk Utility'''


Write a single Linux command to perform the specified tasks for each of the following questions.


# Write a Linux awk command to display all records for the file: '''~/cars''' whose fifth field is greater than 10000.<br><br>
# Write a Linux awk command to display the first and fourth fields for the file: '''~/cars''' whose fifth field begins with a number.<br><br>
# Write a Linux awk command to display the second and third fields for the file: '''~/cars''' for records that match the pattern “chevy”.<br><br>
# Write a Linux awk command to display the first and second fields for all the records contained in the file: '''~/cars'''<br><br>




[[Category:ULI101]]