UNIX and Linux Applications

i had the data in the following form:
Branch : 3379 As On : 31-JAN-2009 Page : 1
User Id : OPER1 Date & Time : 01-FEB-2009 04:02:37

------------------------------------------------------------------------------------------------------------------------------------
Period JAN LCY Amount FCY Amount (LCY Eq) Total

------------------------------------------------------------------------------------------------------------------------------------
Asset

220120100 BALANCE IN C/A-WITH SBI 18,375.58 0.00 18,375.58
220720200 INTEREST RECEIVABLE - JL 0.00 0.00 0.00
220720400 INTEREST RECEIVABLE - OSL 69,564.99 0.00 69,564.99

with Branch:3379 and As on : 31-jan-2009 at the top of the report......

The report contained 5 columns.......

what i want is to have 7 columns of only data (without header and footer)....first column should be the Branch code ie., 3379; second
column should be the date of the report ie., 31-jan-2009 and rest of the
data in the order of 1,2,3,4, and 5th columns in the place of 3,4,5,6, and 7th columns......
Example:
3379 31-jan-2009 220120100 BALANCE IN C/A-WITH SBI 18,375.58 0.00 18,375.58

pl.. help by providing suitable gwak command....

Plz tell what have you tried so far..

sir.. thank u for calling

i tried the following to get the data under the following heads
branch date code total
3379 31012009 220120100 18,375.58
3379 31012009 220720200 0.00
3379 31012009 220720400 69,564.99
3379 31012009 220720600 77,843.76

i could not succeed, the change of character position did not result in
any data...

Code:

                          
{
a=b=0
a=index($0,"Branch  : ")
b=index($0,"As On       :    ")
if ( a > 0 )
   { bic=substr($0,length($0)11,4)
     next
   }
if ( b > 0 )
   { split(substr($0,63,11),datee,"-")
     if ( datee[2]=="jan")
        { mm=01
 }
     if ( datee[2]=="feb")
        { mm=02
 }
     if ( datee[2]=="mar")
        { mm=03
 }
     if ( datee[2]=="apr")
        { mm=04
 }
     if ( datee[2]=="may")
        { mm=05
 }
     if ( datee[2]=="jun")
        { mm=06
 }
     if ( datee[2]=="jul")
        { mm=07
 }
     if ( datee[2]=="aug")
        { mm=08
 }
     if ( datee[2]=="sep")
        { mm=09
 }
     if ( datee[2]=="oct")
        { mm=10
 }
     if ( datee[2]=="nov")
        { mm=11
 }
     if ( datee[2]=="dec")
        { mm=12
 }
     date1=sprintf("%02d%02d%04d",datee[1],mm,datee[3])
     next
   }
ctr=split($0,arr," ")
amt=kod=0
if (ctr > 1)
 {
  for (i=1;i<(ctr+1);i++)
    { 
      if (index(arr[i],".") > 0 )
         { 
           gsub(",","",arr[i])
           gsub("\\.","",arr[i])
           gsub("-","",arr[i])
         }
    }
  for (i=1;i<ctr;i++)
    { 
      if ( (arr[i]    ~ /^[0-9]+$/) && ( arr[i+1] ~ /^[0-9]+$/))
         {
     kod=arr[i]+0
     amt=arr[i+1]+0
            i++
  }
    }
  if ( kod > 100000000 && kod < 999999999 && amt > 0 )
     {
            printf("%04d%08d%09d%013.0f\n",bic,date1,kod,amt*1)                    
     kod=amt=0
     }
    
 }
}

---------- Post updated at 06:44 PM ---------- Previous update was at 06:17 PM ----------

sir.. thank u for calling

i tried the following to get the data under the following heads
branch date code total
3379 31012009 220120100 18,375.58
3379 31012009 220720200 0.00
3379 31012009 220720400 69,564.99
3379 31012009 220720600 77,843.76

i could not succeed, the change of character position did not result in
any data...


Code:
{a=b=0a=index($0,"Branch : ")b=index($0,"As On : ")if ( a > 0 ) { bic=substr($0,length($0)11,4) next }if ( b > 0 ) { split(substr($0,63,11),datee,"-") if ( datee[2]=="jan") { mm=01 } if ( datee[2]=="feb") { mm=02 } if ( datee[2]=="mar") { mm=03 } if ( datee[2]=="apr") { mm=04 } if ( datee[2]=="may") { mm=05 } if ( datee[2]=="jun") { mm=06 } if ( datee[2]=="jul") { mm=07 } if ( datee[2]=="aug") { mm=08 } if ( datee[2]=="sep") { mm=09 } if ( datee[2]=="oct") { mm=10 } if ( datee[2]=="nov") { mm=11 } if ( datee[2]=="dec") { mm=12 } date1=sprintf("%02d%02d%04d",datee[1],mm,datee[3]) next }ctr=split($0,arr," ")amt=kod=0if (ctr > 1) { for (i=1;i<(ctr+1);i++) { if (index(arr[i],".") > 0 ) { gsub(",","",arr[i]) gsub("\\.","",arr[i]) gsub("-","",arr[i]) } } for (i=1;i<ctr;i++) { if ( (arr[i] ~ /^[0-9]+$/) && ( arr[i+1] ~ /^[0-9]+$/)) { kod=arr[i]+0 amt=arr[i+1]+0 i++ } } if ( kod > 100000000 && kod < 999999999 && amt > 0 ) { printf("%04d%08d%09d%013.0f\n",bic,date1,kod,amt*1) kod=amt=0 } }}