Help to generate report

[deepa20]

Hello

I have 2 files , one is master file and another file i am genearting which contains Number of fails for all host & version.

The first file is master file which contains 2 column, Test Case name and Product Name:
daily/DB/attach/attach_redundancy.exp: YRS
daily/DB/help/help.exp: SiCat
daily/DB/hole_fail_rate/hfr-circular.exp: APPS
daily/DB/markerfile/narrow_space_wide_neighbor.ex YRS

The Second File : Fails.log data are like below , the ! is infront of fail record .
/users/testsuite/db/SiCat/2006-09-04/10/kracherl/run.log
! daily/DB/attach/attach_redundancy.exp:
! daily/DB/help/help.exp:
! daily/DB/hole_fail_rate/hfr-circular.exp:
! daily/DB/markerfile/narrow_space_wide_neighbor.exp:
! daily/DB/markerfile/npt.exp:
/users/testsuite/db/SiCat/2006-09-04/10_64/limo/run.log
! daily/DB/measure_stack/ms_objects_transistor.exp:
! daily/DB/network/transistor_exact_active.exp:
! daily/DB/output/error1.exp:
/users/testsuite/db/SiCat/2006-09-04/devel_64/limo/run.log
! daily/DB/hole_fail_rate/hfr-circular.exp:
! daily/DB/markerfile/cws.exp:
! daily/DB/markerfile/narrow_space_wide_neighbor.exp:

Now i want to generate the report like0
Ver Host Total YRS SiCat APPS PSD NO
10 kracherl 34 23 1 2 6 2
10_fast via2 30 18 1 2 7 2
9 optimator 36 29 1 2 4 0

 

[Annihilannic]

It seems like you will need to explain your requirements better if you wish to get some help here.

Have you tried anything yourself?

Annihilannic.

 

[BrianAtWork]

Exactly - for example, you want 10_fast via2 and 9 optimator to appear in your report... Where did those words come from?

Just try to make your need more clear, and show what you've worked on already... Then you may get more response.