bbed 解析数据块

#parameter testing....


# three parameter need to input into------------------------------------------------------
fileno=4
blokst=101004
bloked=101005
datarw=rn3c2nc2t5c


rm block_list 2>/dev/null
rm bbed_table 2>/dev/null
rm bbed_record  2>/dev/null


echo "Get the data use bbed:"


for((i=$blokst;i<=$bloked;i++));do
  #output blockno into blocklist
  ./bbed_blkno "$fileno" "   $i"   2>/dev/null
done;


for bkno in `cat block_list`
do
 echo "fileno:$fileno " "blockno: $bkno"
 bbed parfile=bbed.par  password=blockedit <<EOF  >bbed0_rowno
 set dba $fileno,$bkno
 p kdbhnrow
 exit
EOF




bbed_rowno=`cat bbed0_rowno|grep kdbhnrow |awk '{print $5}'`




block_rowid=$(($bbed_rowno-1))
for((i=$block_rowid;i>=0;i--));do
 bbed parfile=bbed.par  password=blockedit <<EOF  >>bbed_record
 set dba $fileno,$bkno
 p *kdbr[$i]
 x /$datarw
exit
EOF
done;


more bbed_record|grep col|awk '{print $1 $2 ":" $4}'|awk -F  @ '{print $1}' > bbed_table


#end the for statment--------------------------------------------------------------
done;


#rm the temp file-----------------------------------------------------------------
rm bbed_record     2>/dev/null
rm block_list      2>/dev/null
rm *rowno          2>/dev/null
rm bbed_datarecord 2>/dev/null


#format the data----it is very slow ,use better c or c++ dev the code-------------
echo "format data----------"
for bkrow in `cat bbed_table`
do
   if [ "$bkrow" == "cols" ];then
       echo $rowdata >>bbed_datarecord
       rowdata=''
   fi
   bkrow1=`echo $bkrow|awk -F : '{print $2}'`
   rowdata="$rowdata""$bkrow1""|"
 
done


rm bbed_table 2>/dev/null


echo "Format data completed pls check bbed_datarecord file"