shell script

Shell Programming and Scripting
1

Hi All,
I have a source file with the below content.
I need to create an outputfile with the format like (sessionlogname,lookuptransformation name,creating cache timestamp ,cache creation completed timestamp)
by taking the above file as a source.
For each lookuptable ,we will have the corresponding information like lookuptranformation name, creating cache time and cache creation completed time.
So all this information should come up in one line in the outputfile for each occurence of lookup table (lookuptransformation name).
Could you please help me in this shell script.

Below is the sample source file content.

Thanks,
Burwood

-------

source file

(sessionlogname1)TRANSF_1_1_1> CMN_1716 Lookup [lookuptransformationname] uses database connection [Relational:DataWarehouse] in codepage [UTF-8 encoding of Unicode]
TRANSF_1_1_1> DBG_21079 Creating Lookup Cache : (Fri Aug 05 00:46:31 2011)
TRANSF_1_1_1> DBG_21294 Lookup cache creation completed : (Fri Aug 05 00:47:15 2011)
************************
**********************
sessionlogname1
(sessionlogname2)TRANSF_1_1_1> CMN_1716 Lookup [lookuptransformationname] uses database connection [Relational:DataWarehouse] in codepage [UTF-8 encoding of Unicode]
TRANSF_1_1_1> DBG_21079 Creating Lookup Cache : (Mon Aug 08 03:42:15 2011)
TRANSF_1_1_1> DBG_21294 Lookup cache creation completed : (Mon Aug 08 03:42:15 2011)
sessionlogname2
2

If you want people to help you, you should use a descriptive topic name, so people have an idea of if it's in their area of expertise. Additionally include a sample of your input, desired output and what you have tried so far.