How to get multiple rows from a file?

Shell Programming and Scripting
1

Gents,

I have a big file, where I would like to get some rows..

Then file1 contains.

Obs_Report_Result : [                                                           
                                                                                
# ===== (1) =====                                                               
Observer_Report : [                                                             
# ===============                                                               
                                                                                
  Version         : "5.0"                                                             
  Exploitation_Mode     : SLIP SWEEP                                               
                                                                                
  Line_Report     : [                                                              
    Filter_Type             : 8N LIN                                                     
    Aux_Nb_Trace         : 5                                                          
    Seis_Nb_Trace         : 3840                                                      
    Total_Nb_Trace         : 3845                                                     
    Nb_Of_Dead_Seis_Channels     : 0                                               
    Nb_Of_Live_Seis_Channels     : 3840                                            
    Dead_Seis_Channels         :                                                      
    Live_Seis_Channels         : 2856:7121-7360(1-240)                                
                             2866:7121-7360(241-480)                                  
                             2876:7121-7360(481-720)                                  
                             2886:7121-7360(721-960)                                  
                             2896:7121-7360(961-1200)                                 
                             2906:7121-7360(1201-1440)                                
                             2916:7121-7360(1441-1680)                                
                             2926:7121-7360(1681-1920)                                
                             2936:7121-7360(1921-2160)                                
                             2946:7121-7360(2161-2400)                                
                             2956:7121-7360(2401-2640)                                
                             2966:7121-7360(2641-2880)                                
                             2976:7121-7360(2881-3120)                                
                             2986:7121-7360(3121-3360)                                
                             2996:7121-7360(3361-3600)                                
                             3006:7121-7360(3601-3840)                                
    SFL                 : 2856                                                              
    SFN                 : 7121                                                              
    Spread_Nb             : 105                                                          
    Spread_Type             : ABSOLUTE                                                   
    Acq_Error             :                                                              
    ITB                 : FALSE                                                             
  ]                                                                             
                                                                                
  Shot_Report     : [                                                              
    Swath_Name             : 1162                                                        
    Swath_ID             : 61                                                            
    Shot_Nb             : 425                                                            
    Line_Name             :  2775.0                                                      
    Point_Number         :  7240.0                                                    
    Point_Index             : 1                                                          
    Acq_Length             : 18000 # (msec)                                              
    Sweep_Length         : 12000 # (ms)                                               
    Pilot_Length         : 12000 # (ms)                                               
    Record_Length         : 6000 # (ms)                                               
    Sample_Rate             : 2000                                                       
    Total_Nb_Sample         : 3001                                                    
    Type_Of_Source         : VIBRO                                                    
    Source_Nb             : 4                                                            
    Tb_Window             : 20000                                                        
    Date             : Wed Oct 31 00:00:28 2012                                          
                                                                                
    Julian_Day             : 305                                                         
    Cog_State             : ACTUAL                                                       
    Cog_Easting             : 416875.0                                                   
    Cog_Northing         : 2574281.4                                                  
    Cog_Elevation         : 151.1                                                     
    Cog_Deviation         :    6.4                                                    
    Uphole_Time             :  0.00 # (msec)                                             
  ]                                                                             
                                                                                
  Noise_Report     : [                                                             
    Noise_Elim_type         : NE OFF                                                  
    Thres_Hold_Var         : N/A                                                      
    Hist_Editing_Type         : N/A                                                   
    Hist_Range             : N/A # (dB)                                                  
    Hist_Taper_Length         : N/A # (power)                                         
    Hist_Thres_Init_Val         : N/A # (dB)                                          
    Hist_Zeroing_Length         : N/A # (msec)                                        
    Low_Trace_Value         : 0 # (dB)                                                
    Low_Trace_Percent         : 0                                                     
    Noisy_Trace_Percent         : N/A                                                 
    Low_Noisy_Verbose         :                                                       
    Nb_Of_Window         : 0                                                          
  ]                                                                             
                                                                                
  Process_Report     : [                                                           
    Type_Of_Process         : CORREL BEFORE                                           
    Acq_Nb             : 1                                                               
    Correl_Pilot_Nb         : 3                                                       
    Auto_Cor_Peak_Time         : 1000                                                 
    Dump_Stacking_Fold         : 1                                                    
    Max_Of_Max_Aux_Char         : "   2.444985e+16"                                   
    Max_Of_Max_Seis_Char     : "   1.146503e+12"                                   
    Max_Time_Value_Verbose     : "0/1 : 0 455506.22"                               
    Tb_GPS_Time             : 1035666044616001                                           
  ]                                                                             
                                                                                
  Record_Report         : [                                                           
    File_Nb             : 617                                                            
    Type_Of_Dump         : DUMP                                                       
    Type_Of_Test         : N/A 3                                                      
    Tape_Nb             : 6589                                                           
    Tape_Label             : "N7"                                                        
    Record_Type             : NORMAL                                                     
    Blocking_Mode         : FALSE                                                     
    Device_Bypass         : FALSE                                                     
    Tape_Error_Text         : ""                                                      
    Tape_Time             : "Wed Oct 31 00:01:27 2012                                    
"                                                                               
    File_Count             : "609                                                        
    File_Per_Tape         : "9999"                                                    
  ]                                                                             
                                                                                
  Comment             : "N/A"                                                            
  User_Header             : ""                                                           
                                                                                
                                                                                
]                                                                               
# ===== (2) =====                                                               
Observer_Report : [                                                             
# ===============                                                               
                                                                                
  Version         : "5.0"                                                             
  Exploitation_Mode     : SLIP SWEEP                                               
                                                                                
  Line_Report     : [                                                              
    Filter_Type             : 8N LIN                                                     
    Aux_Nb_Trace         : 5                                                          
    Seis_Nb_Trace         : 3840                                                      
    Total_Nb_Trace         : 3845                                                     
    Nb_Of_Dead_Seis_Channels     : 0                                               
    Nb_Of_Live_Seis_Channels     : 3840                                            
    Dead_Seis_Channels         :                                                      
    Live_Seis_Channels         : 2856:7131-7370(1-240)                                
                             2866:7131-7370(241-480)                                  
                             2876:7131-7370(481-720)                                  
                             2886:7131-7370(721-960)                                  
                             2896:7131-7370(961-1200)                                 
                             2906:7131-7370(1201-1440)                                
                             2916:7131-7370(1441-1680)                                
                             2926:7131-7370(1681-1920)                                
                             2936:7131-7370(1921-2160)                                
                             2946:7131-7370(2161-2400)                                
                             2956:7131-7370(2401-2640)                                
                             2966:7131-7370(2641-2880)                                
                             2976:7131-7370(2881-3120)                                
                             2986:7131-7370(3121-3360)                                
                             2996:7131-7370(3361-3600)                                
                             3006:7131-7370(3601-3840)                                
    SFL                 : 2856                                                              
    SFN                 : 7131                                                              
    Spread_Nb             : 109                                                          
    Spread_Type             : ABSOLUTE                                                   
    Acq_Error             :                                                              
    ITB                 : FALSE                                                             
  ]                                                                             
                                                                                
  Shot_Report     : [                                                              
    Swath_Name             : 1162                                                        
    Swath_ID             : 61                                                            
    Shot_Nb             : 456                                                            
    Line_Name             :  2773.0                                                      
    Point_Number         :  7250.0                                                    
    Point_Index             : 1                                                          
    Acq_Length             : 18000 # (msec)                                              
    Sweep_Length         : 12000 # (ms)                                               
    Pilot_Length         : 12000 # (ms)                                               
    Record_Length         : 6000 # (ms)                                               
    Sample_Rate             : 2000                                                       
    Total_Nb_Sample         : 3001                                                    
    Type_Of_Source         : VIBRO                                                    
    Source_Nb             : 3                                                            
    Tb_Window             : 20000                                                        
    Date             : Wed Oct 31 00:00:46 2012                                          
                                                                                
    Julian_Day             : 305                                                         
    Cog_State             : ACTUAL                                                       
    Cog_Easting             : 417375.0                                                   
    Cog_Northing         : 2574227.9                                                  
    Cog_Elevation         : 149.8                                                     
    Cog_Deviation         :    2.8                                                    
    Uphole_Time             :  0.00 # (msec)                                             
  ]                                                                             
                                                                                
  Noise_Report     : [                                                             
    Noise_Elim_type         : NE OFF                                                  
    Thres_Hold_Var         : N/A                                                      
    Hist_Editing_Type         : N/A                                                   
    Hist_Range             : N/A # (dB)                                                  
    Hist_Taper_Length         : N/A # (power)                                         
    Hist_Thres_Init_Val         : N/A # (dB)                                          
    Hist_Zeroing_Length         : N/A # (msec)                                        
    Low_Trace_Value         : 0 # (dB)                                                
    Low_Trace_Percent         : 0                                                     
    Noisy_Trace_Percent         : N/A                                                 
    Low_Noisy_Verbose         :                                                       
    Nb_Of_Window         : 0                                                          
  ]                                                                             
                                                                                
  Process_Report     : [                                                           
    Type_Of_Process         : CORREL BEFORE                                           
    Acq_Nb             : 1                                                               
    Correl_Pilot_Nb         : 3                                                       
    Auto_Cor_Peak_Time         : 1000                                                 
    Dump_Stacking_Fold         : 1                                                    
    Max_Of_Max_Aux_Char         : "   2.444985e+16"                                   
    Max_Of_Max_Seis_Char     : "   1.224311e+12"                                   
    Max_Time_Value_Verbose     : "0/1 : 0 455009.75"                               
    Tb_GPS_Time             : 1035666062640001                                           
  ]                                                                             
                                                                                
  Record_Report         : [                                                           
    File_Nb             : 618                                                            
    Type_Of_Dump         : DUMP                                                       
    Type_Of_Test         : N/A 3                                                      
    Tape_Nb             : 6589                                                           
    Tape_Label             : "N7"                                                        
    Record_Type             : NORMAL                                                     
    Blocking_Mode         : FALSE                                                     
    Device_Bypass         : FALSE                                                     
    Tape_Error_Text         : ""                                                      
    Tape_Time             : "Wed Oct 31 00:01:32 2012                                    
"                                                                               
    File_Count             : "610                                                        
    File_Per_Tape         : "9999"                                                    
  ]                                                                             
                                                                                
  Comment             : "N/A"                                                            
  User_Header             : ""

File output..desired.

 Swath_Name, Swath_ID, Shot_Nb, Line_Name, Point_Number, Tb_GPS_Time, File_Nb, Type_Of_Dump, Type_Of_Test, Tape_Nb, Tape_Label, Date, Comment  
 1162, 61, 425, 2775.0, 7240.0, 1035666044616001, 617, DUMP, N/A 3, 6589,  "N7", Wed Oct 31 00:00:46 2012, "N/A" 
 1162, 61, 456, 2773.0, 7250.0, 1035666062640001, 618, DUMP, N/A 3, 6589,  "N7", Wed Oct 31 00:01:32 2012, "N/A"

Thanks ind advance for your help..

2

With assumptions:

awk 'BEGIN{
head="Swath_Name,Swath_ID,Shot_Nb,Line_Name,Point_Number,Tb_GPS_Time,File_Nb,Type_Of_Dump,Type_Of_Test,Tape_Nb,Tape_Label,Date,Comment"
maxitems=split(head,name,/,/)
for(i in name) num[name]=i}
/^Observer_Report/{f=1;s++;next}
$1 in num{t=$1;$1=$2="";data[s,t]=$0}
END{
if(f)
{
 print head;
 for(i=1;i<=s;i++)
 {
  for(j=1;j<=maxitems;j++)
   printf("%s%s",(j==1?"":","),data[i,name[j]])
  printf "\n"
 }
}
}' file
3

Dear elixier,

Thanks for your quick reply,

I got something like:

,  "N/A" v 11 00:00:46 2012
,  "N/A" v 11 00:01:32 2012

Regards,

4

Some help please..
Thanks

5 
awk -F: 'BEGIN {
print "Swath_Name,Swath_ID,Shot_Nb,Line_Name,Point_Number,Tb_GPS_Time,File_Nb,Type_Of_Dump,Type_Of_Test,Tape_Nb,Tape_Label,Date,Comment";
}
/(Swath_Name|Swath_ID|Shot_Nb|Line_Name|Point_Number|Tb_GPS_Time|File_Nb|Type_Of_Dump|Type_Of_Test|Tape_Nb|Tape_Label|Date|Comment)/ {
sub("^[ \t]*","",$2);sub("[ \t]*$","",$2); if($1 ~ /Comment/) { printf "%s\n", $2; } else { printf "%s,", $2; }
} ' infile