AWK Essential Training

Learn how to manipulate and format data with AWK, a Mac and Linux command-line tool.

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files

1. What Is AWK?

• What is awk?

2. Awk Command Line Basics

• Writing an AWK program
• Working with records, fields, patterns, and actions
• Using AWK command line flags

3. Understanding Records and Fields

• Exploring basic input field separators
• Specifying field and record separators with variables
• Challenge: Change a CSV file to a tab-separated one
• Solution: Change a CSV file to a tab-separated one

4. Understanding Variables and Operators

• Using built-in variables
• Creating user-defined variables
• Working with operators and arrays

5. A Quick Introduction to Regular Expressions

• Regular expression basics
• Working with character classes and quantifiers

6. Using Control Structures

• Building control structures
• Creating an HTML table
• Challenge: Print only those lines consisting of a complete HTML entity
• Solution: Print only those lines consisting of a complete HTML entity

7. Formatting the Output

• Formatting output with printf()
• Formatting output with width and precision specifiers

8. Functions and Arrays

• Manipulating strings
• Using associative arrays
• Introducing awk's math functions

9. Combining AWK with Other Tools

• Using pipes
• Parsing Excel CSV files: line endings and quoting
• Parsing Excel CSV files: commas and newlines
• Scripting with AWK
• Challenge: Perform a join
• Solution: Perform a join

Conclusion

• Conclusion