Shell Programming and Scripting

Code:

#!/bin/ksh93

while read line
do
   if [[ $line =~ 'LOCATION' ]]; then
     location=$line
   fi
   if [[ $line =~ 'unknown' ]]; then
      echo "$location,$line"
   fi
done < file

Thanks everyone for your responses. ctsgnb, your code almost worked perfectly, and it is my fault for not posting the exact file as it is. Your code printed the line after the line that I need, this is because there is a heading above the lines which I failed to include - Sorry! I tried tweaking the code a bit but I do not know nawk well enough to understand exactly what is going on there. Any insight would be appreciated. Thanks again for your help and sorry that my initial input file was not correct:

Date
Report

LOCATION: M1

Headings
line
line
line
19,8300,unknown,
line
line

LOCATION: B

Headings
line
13,eeee,unknown,eooeo
line
line

LOCATION: CL 1-2

Headings
line
line
line
line

LOCATION: CL 1-1

Heading
line
line
line

LOCATION: CL 2-2

Heading
line
line
line

LOCATION: CL 2-1

Heading
line
5,TICKLISH,unknown,83838388383
line
line

the code

Code:

nawk '/^LOCATION:/{x=$0}x&&/unknown/{print x,$0;x=z}' infile

should still work ... or do you expect another output ???

Beautiful! Thanks...I hadn't tried that one

---------- Post updated at 03:14 PM ---------- Previous update was at 11:33 AM ----------

Actually, one more quick question, I am trying to import these items to a .csv file which I am doing with a redirection >> .csv
However, I wanted to have a comma between the end of the LOCATION and the first integer in the line with 'unknown'...see below:
LOCATION: M1,19,8300,unknown,
LOCATION: B,13,eeee,unknown,eooeo
LOCATION: CL 2-1,5,TICKLISH,unknown,83838388383

This way I can easily open it in excel and have everything in seperate columns. The problem I am running into is that some of the locations have more fields than others so depending on what I use as the delimiter it seperates the locations.

Then just enclose the coma in double quote :

Code:

nawk '/^LOCATION:/{x=$0}x&&/unknown/{print x","$0;x=z}' infile

Oh okay...thanks!!