Shell Programming and Scripting

### Line 1 ####
Transformation||Transformation Mapplet Name||Transformation Group||Partition Index||Transformation Row ID||Error Sequence||Error Timestamp||Error UTC Time||Error Code||Error Message||Error Type||Transformation Data||Source Mapplet Name||Source Name||Source Row ID||Source Row Type||Source Data 
### Line 2 ####
exp_Concat||N/A||Input||1||4||1||03/01/2010 08:42:33||1267450953||11132||Transformation [exp_Concat] had an error evaluating output column [ID_OUT]. Error message is [<<Expression Fatal Error>> [ABORT]: ID CANT BE NULL VALUE\n... f:ABORT(u:'ID CANT BE NULL VALUE')].\n||3||N:,D:VENKAR,D:CON,D:HYD,D:367288.0000000000||N/A||SQ_EMP||4||0||N:,D:VENKAR,D:CON,D:HYD,D:367288.0000000000
### Line 3 ####
lkp_Concat||N/A||Input||1||3||1||03/01/2010 08:42:33||1267450953||11132||NULL||3||N:,D:VENKAR,D:CON,D:HYD,D:367288.0000000000||N/A||SQ_EMP||4||0||N:,D:VENKAR,D:CON,D:HYD,D:367288.0000000000

Transformation = exp_Concat
Transformation Mapplet Name = N/A
.
.
.
Source Data = N:,D:VENKAR,D:CON,D:HYD,D:367288.0000000000

Transformation = lkp_Concat
Transformation Mapplet Name = N/A
.
.
.
Source Data = N:,D:VENKAR,D:CON,D:HYD,D:367288.0000000000

sed 's/||/|/g' file | awk 'BEGIN{FS="|"}NR==1{for(i=1;i<=NF;i++)head[i]=$i}NR>1{for(i=1;i<=NF;i++)print head[i],"=",$i}'

j=0
for line in `sed 's/ //g;s/||/|/g' Transinput`
do
if [[ `echo $line|grep -v "^#.*"` ]];then
if [[ $j -eq 0 ]]
then
for((k=1;k<=17;k++))
do
arr[$k]=`echo $line | cut -d '|' -f $k `
done
let j+=1
else
for((k=1;k<=17;k++))
do
echo "${arr[$k]} = `echo $line | cut -d '|' -f $k `"
done
echo -e "\n"
let j+=1
fi
fi
done