Comma Values in column

[#1]

HI all,

I have a situation in which Applymap and simple widmatch is not working.I have a column which contains following data

col1          col2

1               Duplicate

2               required filed missing:abcd,Duplicate

3               required filed missing:abcd,pqrs,Duplicate           

4               required filed missing:xyz

5               Member Not found

Now in filter I want to show:

Duplicate

Required Field Missing

Member Not Found

Now On selecting :

Duplicate:: records 1,2,3 show.

Required Field Missing:: records 2,3,4 show

Member Not Found:: record 5 show.

I search lot about this,but not able achieve this.Please help regarding this.

[#2]

Ok,I will mark it.@Mssiomo I have also posted a query regarding date range selection from calender objects.I have attached a test qvw now.Can you please see it and provide help if possible.

My query was::"Table Box filters records by selecting date range from two calender objects"