Changes

Tutorial11: Sed & Awk Utilities

3 bytes added, 10:28, 6 March 2021

→‎INVESTIGATION 2: USING THE AWK UTILITY

# Issue the following linux pipeline command all to display records in the '''cars.txt''' database that contain the pattern (i.e. make) '''ford''': awk '/ford/' cars.txt | tee awk-1.txt What do you notice? You should notice ALL lines displayed without using a search criteria. You can use these '''variables''' with the '''print''' command for further processing. We will discuss the following variables in this tutorial: [[Image:awk-2.png|thumb|right|400px|Using the awk command to print search results by '''field number'''.]]'''$0''' - Current record (entire line) '''$1''' - First field in record '''$n''' - nth field in record '''NR''' - Record Number (order in database) '''NF''' - Number of fields in current record For a listing of more variables, please consult your course notes.

# Issue the following linux pipeline command to display the '''model''', '''year''', '''quantity''' and price in the '''cars.txt''' database for makes of '''chevy''': awk '/chevy/ {print $2,$3,$4,$5}' cars.txt | tee awk-2.txt Notice that a space " " is the delimiter for the fields that appear as standard output.

# Issue the following linux pipeline command to display all '''plymouths''' ('''plyms''') by '''model name''', '''price''' and '''quantity''': awk '/chevy/ {print $2,$3,$4,$5}' cars.txt | tee awk-3.txt 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 '''<'''     Less than '''<='''   Less than or equal '''>'''     Greater than '''>='''   Greater than or equal '''=='''   Equal '''!='''    Not equal

# Issue the following linux pipeline command to display display the car make, model number, quantity and price of all vehicles that are prices less than $5,000: awk '$5 < 5000 {print $1,$2,$4,$5}' cars.txt | tee awk-4.txt What do you notice?

# Issue the following linux pipeline command to display display the car make, model number, quantity and price of all vehicles that are prices less than $5,000: awk '$5 < 5000 {print $1,$2,$4,$5}' cars.txt | tee awk-5.txt The symbol tilde '''~''' is used to match a pattern for a particular field number. The '''tilde character''' '''~''' is used to search for a pattern or display standard output for a particular field.

Msaul

Administrators

13,420

edits

CDOT Wiki β

Changes

Tutorial11: Sed & Awk Utilities

CDOT Wiki ^β