Data Handling using AWK & SED

Course Overview

Suitable for Systems or Database administrators who need to write scripts to handle and convert data within the UNIX environment. This course will cover all aspects of Regular expressions, the SED editor and the very powerful AWK programming language.

On completion of the course delegates will be able to understand, design, code and debug complex AWK and SED scripts. The student will be able to code portable scripts for all UNIX platforms. The course will cover the following:,The differences between AWK, OAWK and NAWK ,Invoking AWK/SED scripts ,Using Regular Expressions ,SED - The stream Editor ,Pattern { action } within AWK ,Looping Constructs in AWK ,In-built and user functions ,Pattern matching ,Advanced Topics,Putting it all together

Delegates should have a basic understanding of the UNIX Operating system and be proficient in use of the Korn or Bourne shell interface.

Regular Expressions
Matching single & multiple characters
Anchoring search patterns
Saving & recalling patterns
Extended Regular Expressions
The Stream Editor
How sed processes data streams
SED mechanics & syntax
Search and Replacement
Displaying Edited Lines Only
Complex edit patterns

AWK Functionality
AWK/OAWK & NAWK
Pattern { Action }
Fields & Records
AWK programs
Action Constructs
Built In Variables
Multi-line commands

Pattern Matching within AWK
Pattern Matching using Regular Expressions
Assigning and Using Variables
Numeric Operations, typecasting integer
Matching multiple patterns

Looping Constructs
Controlling flow using loop constructs
The For Loop
The While Loop
The Break & Continue Statements
String, mathematical
and system functions
String & In-built Function utilities
Using in-built string variables
Mathematical functions
System function calls
Accessing the Shell environment

Using User Defined Functions
Functions and subroutines: Design policy
Calling functions at run-time
Passing parameters to functions
Passing back output from functions

Advanced Features
Passing Variables & Parameters
The getline facility
Pipes & Re-Direction
Single array processing : Associative arrays
Multi-Dimension arrays