Data filter according to specific strings

[bala06]

Dear Excel users

I would like to filter my data according to specific character or strings.

My data is presented as a text in excel sheet. Say for example

719-hydrogen-bond-frame.dat.c.d.lw 719-hydrogen-bond-frame.dat.c.d.pw [(4733, 'UNK', 'X 900B', 61240, 'SPC', 'X2ed8G', 61241, 'SPC', 'X2ed8G', 1327, 'ASP', 'A 138B')]
722-hydrogen-bond-frame.dat.c.d.lw 722-hydrogen-bond-frame.dat.c.d.pw [(4732, 'UNK', 'X 900B', 56752, 'SPC', 'X2900G', 56754, 'SPC', 'X2900G', 4186, 'ASN', 'A 363B'), (4733, 'UNK', 'X 900B', 61240, 'SPC', 'X2ed8G', 61241, 'SPC', 'X2ed8G', 1327, 'ASP', 'A 138B')]
724-hydrogen-bond-frame.dat.c.d.lw 724-hydrogen-bond-frame.dat.c.d.pw [(4732, 'UNK', 'X 900B', 56752, 'SPC', 'X2900G', 548, 'ARG', 'A 88B', 4748, 'UNK', 'X 900B'), (4733, 'UNK', 'X 900B', 61240, 'SPC', 'X2ed8G', 548, 'ARG', 'A 88B', 4748, 'UNK', 'X 900B')]
726-hydrogen-bond-frame.dat.c.d.lw 726-hydrogen-bond-frame.dat.c.d.pw [(35871, 'SPC', 'X3535G', 4711, 'UNK', 'X 900B', 2610, 'PHE', 'A 218B', 35869, 'SPC', 'X3535G')]
728-hydrogen-bond-frame.dat.c.d.lw 728-hydrogen-bond-frame.dat.c.d.pw [(4733, 'UNK', 'X 900B', 61240, 'SPC', 'X2ed8G', 61241, 'SPC', 'X2ed8G', 1327, 'ASP', 'A 138B')]
731-hydrogen-bond-frame.dat.c.d.lw 731-hydrogen-bond-frame.dat.c.d.pw [(4733, 'UNK', 'X 900B', 61240, 'SPC', 'X2ed8G', 61241, 'SPC', 'X2ed8G', 1327, 'ASP', 'A 138B')]
733-hydrogen-bond-frame.dat.c.d.lw 733-hydrogen-bond-frame.dat.c.d.pw [(4733, 'UNK', 'X 900B', 61240, 'SPC', 'X2ed8G', 61241, 'SPC', 'X2ed8G', 1327, 'ASP', 'A 138B')]
734-hydrogen-bond-frame.dat.c.d.lw 734-hydrogen-bond-frame.dat.c.d.pw [(33096, 'SPC', 'X2610G', 4711, 'UNK', 'X 900B', 2610, 'PHE', 'A 218B', 33094, 'SPC', 'X2610G')]


Form this data, I would like to filter only lines containing UNK and A 138B as true and others as false. The both character UNK and A 138B should be matched within single brackets, if its matches with different brackets it should not be considered. Since the data as presented as text, the given formula should consider whole length of the text.

Thanks for all your help.

Balaji

 

[Andrew Poulsom]

You can use a formula like:

=ISNUMBER(SEARCH("[*UNK*A 138B*]",A1))

and AutoFilter that column for TRUE.

 

[bala06]

You can use a formula like:

=ISNUMBER(SEARCH("[*UNK*A 138B*]",A1))

and AutoFilter that column for TRUE.

Dear Andrew

It works.

Many Thanks
Balaji