filter data

[bala06]

Dear Excel Users

<table id="post2757829" class="tborder" align="center" border="0" cellpadding="6" cellspacing="0" width="100%"><tbody><tr valign="top"><tr valign="top"><td class="alt1" id="td_post_2757829" style="border-right: 1px solid #FFFFFF">

FIlter Data
<hr style="color:#FFFFFF; background-color:#FFFFFF" size="1"> Dear Excel Users

I would like to filter the filter the data according to certain numbers.

For example my data looks like this

1049 1049-hydrogen-bond-frame.dat.c.d.lw 1049-hydrogen-bond-frame.dat.c.d.pw [(34652 'SPC' 'X2591G' 4758 'UNK' 'Z1203B' 34653 'SPC' 'X2591G' 3895 'LYS' 'A 347B') (57086 'SPC' 'X2755G' 4733 'UNK' 'Z1203B' 57087 'SPC' 'X2755G' 3895 'LYS' 'A 347B')]
1054 1054-hydrogen-bond-frame.dat.c.d.lw 1054-hydrogen-bond-frame.dat.c.d.pw [(34652 'SPC' 'X2591G' 4758 'UNK' 'Z1203B' 34653 'SPC' 'X2591G' 3895 'LYS' 'A 347B')]
1055 1055-hydrogen-bond-frame.dat.c.d.lw 1055-hydrogen-bond-frame.dat.c.d.pw [(34652 'SPC' 'X2591G' 4758 'UNK' 'Z1203B' 34653 'SPC' 'X2591G' 3895 'LYS' 'A 347B') (4715 'UNK' 'Z1203B' 34653 'SPC' 'X2591G' 34653 'SPC' 'X2591G' 3895 'LYS' 'A 347B') (57086 'SPC' 'X2755G' 4733 'UNK' 'Z1203B' 57087 'SPC' 'X2755G' 3895 'LYS' 'A 347B') (57086 'SPC' 'X2755G' 4733 'UNK' 'Z1203B' 57087 'SPC' 'X2755G' 3947 'HIS' 'A 350B')]

I have to filter the data based on two numbers "4758 and 3895" and my final output should like this

1049 - 4758 3895
1054 - 4758 3895
1055 - 4758 3895

But the in my data, this numbers varies at different position according to length of the data. The numbers may present at any bracket and the number of brackets varies on the length of the text.

Kindly advice. I am struggling in this exercise since yesterday.

Any help is greatly appreciated.

Many Thanks
Balaji
</td></tr></tr></tbody></table>