Buy and Download - Lynda.com AWK Essential Training

2014
Lynda
David D. Levine
2h 1m
English

So you've got a large data set. New information is always coming in, and it's messy and inconsistent. Text files, Excel spreadsheets, web forms, email messages, and so on. You'd like to find a way to format it into something clean and consistent you can use in a database, and you'd like to automate that process as much as possible. Enter AWK, a command-line tool for Mac, Unix, and Linux that allows you to manipulate data in powerful ways.

In this course, award-winning author and teacher David D. Levine shows you how to use AWK to read and write data in a variety of formats, produce reports, and automate repetitive tasks. He reviews the nuts and bolts of the language, such as field separators, pattern matching, variables, operators, expressions, and control structures; functions available for manipulating data; and integration with other programs like Excel.
Topics include:

What is AWK?
Writing an AWK program
Working with records, fields, patterns, and actions
Specifying field and record separators with variables
Using built-in and user-defined variables
Building control structures
Formatting output
Manipulating string data with functions
Scripting with AWK

Introduction 2m 16s
Welcome 1m 3s
What you should know before watching this course 43s
Using the exercise files 30s
1. What Is AWK? 3m 11s
What is AWK? 3m 11s
2. AWK Command Line Basics 14m 30s
Writing an AWK program 2m 52s
Working with records, fields, patterns, and actions 5m 20s
Using AWK command-line flags 6m 18s
3. Understanding Records and Fields 12m 7s
Exploring basic input-field separators 3m 41s
Specifying field and record separators with variables 6m 18s
Challenge: Change a CSV file to a tab-separated one 23s
Solution: Change a CSV file to a tab-separated one 1m 45s
4. Understanding Variables and Operators 17m 47s
Using built-in variables 7m 0s
Creating user-defined variables 6m 39s
Working with operators and arrays 4m 8s
5. A Quick Introduction to Regular Expressions 10m 37s
Regular expression basics 5m 19s
Working with character classes and quantifiers 5m 18s
6. Using Control Structures 12m 44s
Building control structures 4m 14s
Creating an HTML table 4m 45s
Challenge: Print only those lines consisting of a complete HTML entity 46s
Solution: Print only those lines consisting of a complete HTML entity 2m 59s
7. Formatting the Output 7m 15s
Formatting output with printf() 3m 20s
Formatting output with width and precision specifiers 3m 55s
8. Functions and Arrays 14m 9s
Manipulating strings 7m 28s
Using associative arrays 4m 55s
Introducing AWK's math functions 1m 46s
9. Combining AWK with Other Tools 25m 47s
Using pipes 7m 6s
Parsing Excel CSV files: Line endings and quoting 5m 34s
Parsing Excel CSV files: Commas and new lines 4m 3s
Scripting with AWK 4m 56s
Challenge: Perform a join 1m 13s
Solution: Perform a join 2m 55s
Conclusion 1m 11s
Goodbye 1m 11s

http://www.lynda.com/Linux-tutorials/AWK-Essential-Training/162719-2.html