help with processing a file

Shell Programming and Scripting
1

I have a file with header and data rows. I need to remove the header rows from the file and use the data rows for my processing.
The problem is the header is not always constant number of rows. But the only way to identify the last row of the header is that it has
the header information of each coulmn in the table. The last column will be flights scheduled

data row

I need to slice off the header and then process the data rows. I thought i can use grep to get the line number where flights scheduled
is and then use it to remove the header. but couldn't get it to work. Any help is appreciated

2

Hi
Try this:

 sed '/^\"Flight Report/,/flights scheduled\"$/d' file
3 
$
$
$ cat f3
"Flight Report"
"Report:","Flight Report "
"Prepared for:","Robin hood "
"Report Start:","Sat May 01 13:36:36 PDT 2010"
"Report End:","Mon May 31 13:36:36 PDT 2010"
"Date Run:","06/15/2010"
"Report Warning:","The following flights were not up to date when this report was generated: CAA (05/26/2010)"

"flight ID","flight Name","route Name","Creative flier","flights scheduled"
"10451","DL4567","aLA-BHM","678905","y"
"10452","DL4568","aLA-BHM","678906","z"
$
$
$ perl -lne 'print if $start; $start=1 if /^"flight ID"/' f3
"10451","DL4567","aLA-BHM","678905","y"
"10452","DL4568","aLA-BHM","678906","z"
$
$

tyler_durden

4 
grep ^\"[0-9] file

---------- Post updated at 17:39 ---------- Previous update was at 17:34 ----------

$ IFS=','
$ grep ^\"[0-9] file | while read fi fn rn cf fs; do
echo $fi - $fn - $rn - $cf - $fs
done
"10451" - "DL4567" - "aLA-BHM" - "678905" - "y"
$
5

awesome guys. all solutions are working. Thanks.