Saturday, 16 August 2014

Awk - UNIX Command and Its Use in ETL Testing

  Introduction              This document describes the possible ways of using the awk command in UNIX, its advantages and different usages with examples and an ETL case study Usage awk –F\<<delimiter>> ‘{print $0}’ <<file name>> Ex:  awk –F\| ‘{print $0}’ Unix_File.dat This command will display all the records in the file Unix_File.dat ‘|’ is the delimiter ‘$0’ refers to the entire set of records This is as good as cat <<filename>> Purpose The purpose of awk command is to know exactly what value is present in particular column of a flat file on UNIX and also to display the records that match a particular criteria. If cat command is used, user may have to manually...

Pages 61234 »