awk

awk is an interpreted programming language that searches for pattern in a set of files and performs the specified action in it. It picks the data even from the ordered data sets like spread sheets.It takes each line in a file as a separate record and the individual line as a separate field. As like any other programming language awk contains variables and functions. It also contains arithmetic, string operators and can generate formatted reports on its own.