Lynda - AWK Essential Training | 218MB

Duration: 2h 01m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1ch

Genre: eLearning | Level: Intermediate | Language: 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