#-------------------------------------------------------------------------------- # summarize columns #-------------------------------------------------------------------------------- awk '{i_sum += $2}; END {print i_sum}' < file.log # | # +--> add column 2 awk '{i_sum2 += $2; i_sum3 += $3}; END {print i_sum2":"i_sum3}' < file.log # | | # +-------------+--> add column 2 and 3 #-------------------------------------------------------------------------------- # substring #-------------------------------------------------------------------------------- export s_start=2 export s_length=3 export s_string=DED5011 echo $s_string | awk '{ print substr( $0, '$s_start', '$s_length' ) }' #-------------------------------------------------------------------------------- # print shell variable within awk #-------------------------------------------------------------------------------- awk '{print "blabla " $6 "'" $s_Month "'" $7, $8, $9, $10}' #-------------------------------------------------------------------------------- # print quotes and double quotes within awk #-------------------------------------------------------------------------------- echo SERVER_HOST | awk '{print " SYS_CONTEXT ('"'"'USERENV'"'"','"'"'" $1 "'"'"') \42" $1 "\42,"}' echo SERVER_HOST | awk '{print " SYS_CONTEXT (\47USERENV\47,\47" $1 "\47) \42" $1 "\42,"}'