Awk

Awk is a powerful language mainly for data extraction. My main use has been to extract specific records or fields from large data set files before further analyzing in Excel or other text editors. Some data sets I have worked with have been so large that Excel is unable to load the data set, which has required initial data extraction by either extracting only the required combination of records or fields of the data set.