Shell Programming and Scripting

I have a file with the data as follows..

FILE 1|#START|Jan 22 15:03
FILE 1|#END|Jan 22 16:06
FILE 2|#START|Jan 22 5:15
FILE 2|#END|Jan 22 5:25
FILE 3|#START|Jan 22 07:03
FILE 3|#END|Jan 22 08:15
FILE 4|#START|Jan 22 16:09
FILE 4|#END|Jan 22 16:55
FILE 1|#START|Jan 22 18:15
FILE 1|#END|Jan 22 18:25

I need to get a .csv file with the format
FILE NAME,START TIME,END TIME

The problem is for the file FILE1,there are two entries...When i am trying to get that format using a loop i am getting second END time,(overcoming first END time)..Can u people suggest some solution...

Each entry should be on its own line, no matter how many times that line appears. For the example you gave, you have two start times and two end times. What is the problem? What script are you using?

Not sure if it's what you want, but here you go:

Code:

awk -F\| 'BEGIN{OFS=","} $2 ~ /START/ {n=$1; t=$3; next} $2 ~ /END/ && $1 == n {print n,t,$3}' infile
FILE 1,Jan 22 15:03,Jan 22 16:06
FILE 2,Jan 22 5:15,Jan 22 5:25
FILE 3,Jan 22 07:03,Jan 22 08:15
FILE 4,Jan 22 16:09,Jan 22 16:55
FILE 1,Jan 22 18:15,Jan 22 18:25

Similar to zaxxons approach:

Code:

awk 'BEGIN{FS="|"; } $2~/START/{printf "%s,%s,",$1,$3} $2~/END/{print $3}' infile

Thanks a ton for ur reply..but the problem is if a FILE has more than one entry,each having their corresponding start and end times..I wrote a while loop to get the following format(.csv file)
FILE NAME,START TIME,END TIME

But i am not gettin correspondin end time using this loop.I am getting the last end time(for the files which have more than one entry)

Have you solved this problem yet?