Hi
i have a text file with the following lines of data
JOB DESCRIPTION FR SA SU MO TU WE TH FR SA SU MO TU WE TH FR SA SU -+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---+---
CL5987A7 MON-FRI @0345CT(CL*A8 NOTE)-NDM TH-8RZRRF 03/05/12 | | | | | | | | | | | | | | * | *| | | | | | |

PL5987JS ALL @ 1900(CL59872A NOTE) - NDM JP-8VJB9C 06/26/12 | | | | | | | | | | * | * | | | * | | | | | | | |

C5987J1 ALL @1900 (CL59871N NOTE) - NDM JP-8VJB9C 06/25/12 | | | | | | | | | | | | | | | | | | | | | | |

i should have the above Text file in the below manner in excel



JOB ID JOB DESCRIPTION Fri 1-Aug sat2-Aug sun3-Aug mon4-Aug tue5-Aug wed6-Aug thu7-Aug Aug
CL5987A7 MON-FRI @0345CT(CL*A8 NOTE) Y Y Y
CL5987JS ALL @ 1900(CL59872A NOTE) Y Y Y



the JOB ID should be in cell A,the JOB DESCRIPTION in cell B,the dates each in one column(AUG 1)in c and (AUG 2)in D
and so on and after that i have display only the data according to the name of the job ID
Example: if job id starts with "C" ( CL5987A7) i have to display only those entire columns with "C" row and Job ID which starts with P i should display only the columns


Note:The * character must be replaced with Y exactly on the same position on the excel date on which date it is present
the "|" should be deleted and the description should have only theses contents the others must be deleted
Example
in job description present in text file
MON-FRI @0345CT(CL*A8 NOTE)-NDM TH-8RZRRF 03/05/12 only MON-FRI @0345CT(CL*A8 NOTE) should be displayed under job description in excel ,kindly help me with the above concern...
thank you