1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| while read ligne
do
serv=`echo $ligne|awk -F"|" '{printf ("%d",$1)}'`
date=`echo $ligne|awk -F"|" '{printf ("%s",$2)}'`
val1=`echo $ligne|awk -F"|" '{printf ("%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",$3,$4,$5,$6,$7,$8,$9,$10,$11,$12)}'`
dom2=`echo $ligne|awk -F"|" '{if(NF>=13){printf ("%d",$13)} else {print "null"}}'`
dom3=`echo $ligne|awk -F"|" '{if(NF>=14){printf ("%d",$14)} else {print "null"}}'`
dom4=`echo $ligne|awk -F"|" '{if(NF>=15){printf ("%d",$15)} else {print "null"}}'`
dom5=`echo $ligne|awk -F"|" '{if(NF>=16){printf ("%d",$16)} else {print "null"}}'`
dom6=`echo $ligne|awk -F"|" '{if(NF>=17){printf ("%d",$17)} else {print "null"}}'`
dom7=`echo $ligne|awk -F"|" '{if(NF>=18){printf ("%d",$18)} else {print "null"}}'`
dom8=`echo $ligne|awk -F"|" '{if(NF>=19){printf ("%d",$19)} else {print "null"}}'`
echo insert into tab_stat_app_jour
echo "values ($serv,'$date',$val1,$dom2,$dom3,$dom4,$dom5,$dom6,$dom7,$dom8);"
done<servdom300310.txt>scr_servdom300310.sql |
Partager