Join David D. Levine for an in-depth discussion in this video Challenge: Perform a join, part of AWK Essential Training.
So here's your final project to tie together everything we've seen so far.…The file nameemailavg.csv contains 19 names, emails, and bowling averages.…The file addresses.txt contains full address information on…those 19 bowlers, plus hundreds of other people.…Can you use AWK to produce a tab-seperated file with the name, mailing address, and…bowling average of those 19 people, combining information from the two files?…The nameemailavg.csv file is comma-separated and has…three fields: full name, email, and bowling average.…
The addresses.txt file is tab-separated and has 12 fields: first name, last name,…company, address, city, county, state, zip, two phone numbers, email and website.…Can you use AWK to produce a tab-separated…file with the following three pieces of information…about the 19 bowlers in nameemailavg.csv: name, mailing…address, and bowling average rounded to the nearest integer?…You have 20 minutes.…
Author
David D. Levine
Released
5/21/2014In 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.
- Determine what AWK is.
- Recognize how to write an AWK program.
- Determine how to use AWK command-line flags.
- Identify how to specify field and record separators with variables.
- Distinguish how to change a CVS file to a tab-separated one.
- Break down how to work with operators and arrays.
- Discover how to format output.
- Interpret how to string data with functions.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome59s
-
-
1. What Is AWK?
-
What is AWK?3m 11s
-
-
2. AWK Command Line Basics
-
Writing an AWK program2m 51s
-
Using AWK command-line flags6m 18s
-
-
3. Understanding Records and Fields
-
4. Understanding Variables and Operators
-
5. A Quick Introduction to Regular Expressions
-
Regular expression basics5m 19s
-
-
6. Using Control Structures
-
Building control structures4m 14s
-
Creating an HTML table4m 45s
-
-
7. Formatting the Output
-
8. Functions and Arrays
-
Manipulating strings7m 28s
-
Using associative arrays4m 55s
-
-
9. Combining AWK with Other Tools
-
Using pipes7m 6s
-
Scripting with AWK4m 56s
-
Challenge: Perform a join1m 13s
-
Solution: Perform a join2m 55s
-
-
Conclusion
-
Goodbye1m 10s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Challenge: Perform a join