UNIX for Advanced & Expert Users

 file1.xml loadOperation="InsertOrUpdate">
 file2.xml loadOperation="Update">
 file3.xml loadOperation="Update">
 file4.xml loadOperation="Append">

<DataMapping123 xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="DataMappping123.xsd" name="fileOperation_1_type" table="XYZ" loadOperation="Stage" sourceTable="ABC">

<DataMapping533 xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="DataMappping533.xsd" name="fileOperation_15_type" table="XYZ" loadOperation="Append">

head -2 fileName2.xml|tail -1 |awk '{print $NF}'

$ head -2 fileName1.xml|tail -1 |awk -v col=loadOperation '{if ($NF==col) {print $NF} else {print $(NF-1)}}'

for logTime in `ls *.xml`; do logTailString=`head -2 $logTime|tail -1 |<<here goes the proper awk script>>; echo "$1 $logTime $logTailString"; done

awk 'FNR == 2 {print FILENAME, ($NF ~ /^load/)?$NF:$(NF-1)}' *.xml

for file in *.xml
do
    awk 'FNR == 2 {print FILENAME, ($NF ~ /^load/)?$NF:$(NF-1)}'  $file
done