Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
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.
Hi, I'm David D. Levine and welcome to AWK Essential Training. AWK is a command line tool for Mac, Linux, and UNIX environment that allows you to manipulate text in very powerful ways. In this course, I'll show you how to use AWK to read and write data in a variety of formats, produce reports and other output for viewing on screen or for use by other programs and automate repetitive tasks. First, I'll walk you through the basic structure of an AWK program.
Then I'll dive into the nuts and bolts of using AWK. I'll show you how to use field separators, pattern matching, variables, operators, and control structures. Then you'll see some of the more advanced printing, string, array, and math functions. Finally, I'll show you how to integrate our programs together with other tools, including Microsoft Excel. AWK's longevity and continued popularity demonstrate how useful it is. Once you've taken this course, I'm sure you will see many ways in which it can help you every day. So, let's get started with AWK Essential Training.
There are currently no FAQs about AWK Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.