UNIX for Dummies Questions & Answers

I need help in parsing the following log files.

10 Apr 2009 0:16:16 [6|1|3|2] * name: Tuna Belly Format: Well done, Price: 999 only
10 Apr 2009 0:16:16 [4|0|3|2] * name: Roast Beef Format: Raw, Price: 55 c
10 Apr 2009 0:16:16 [5|5|4|2] * name: Pasta Format: Dry, Price: 88.43 only
etcetc

I need to parse this to get three columns containing the format and price
6 Well done 999 only
6 Raw 55c
6 Dry 88.43
etcetc
6 is the 1st digit in [6|1|3|2].

I've tried using awk with substring but it stil cant get the desired result
Thanks

awk -F '\[|\||:|,' '{print $4, $9, $11}'

i forgot to mention that the log file contains many data:

ex.
10 Apr 2009 0:16:16 [6|1|3|2] * name: Tuna Belly Format: Well done, Price: 999 only
data data data data etc etc
data data data data etc etc
data data data data etc etc
10 Apr 2009 0:16:16 [4|0|3|2] * name: Roast Beef Format: Raw, Price: 55 c
data data data data etc etc
data data data data etc etc
data data data data etc etc
10 Apr 2009 0:16:16 [5|5|4|2] * name: Pasta Format: Dry, Price: 88.43 only
data data data data etc etc
data data data data etc etc
data data data data etc etc

will the script -> awk -F '\[|\||:|,' '{print $4, $9, $11}' still be able to identity only desired line?
thanks

Without seeing the specifics of the OTHER records/lines, we can only guess.
The guess is based on the number of fields - greater or equal to 11:

Code:

nawk -F '([[]|[|]|:|,)' 'NF>=11{print $4, $9, $11}' myFile

10 Apr 2009 0:16:16 [6|1|3|2] * name: Tuna Belly Format: Well done, Price: 999 only
14 Apr 2009 0:00:57 [6|1|3|2] * Order menu: 'D:\resto/menu/etcetc' opened ( 2 of
7 )
14 Apr 2009 0:00:57 [6|1|3|2] * Order: 18

well they all have different number of fields, i'll try your scripts. thanks.

Well.... then you'd need to identify the 'desired' fields somehow differently.

is this possible?

awk -F '([[]|[|]|:|,)' 'NF>=11 && substr($0,$32,$4)=="name" {print $4, $9, $11}' myfile.log

because unfortunately there are two lines that have greater than 11 lines, so the script also prints out the other lines.