Multifilter in same column

[Jeeru_venkat_Rao]

Hi Friends,

I have a query for multifilters in same column.

I need to extract records which contains- MA, MMA, Medicaid only from below data.

Output should be like:-
Manhattan of MA
PVR MMA
Self-Pay MA CIGNA
Austra Strategies Medicaid
CENPATICO SUNSHINE MEDICAID

Note:- MARKETPLACE, MAKER etc these also contains MA but I need only MA which don’t contain anything in end and begin.

I am using filterdatatable. Everything is working but this MA records not working correctly, if i use contains then it extract all records.

Please suggest

[Jeeru_venkat_Rao]

Multifilter Query.xlsx (9.0 KB)
Sample file

[rashmisingh2695 (Rashmi)]

Hi @Jeeru_venkat_Rao,

Try to use this linq query

If((From row In dtInput.AsEnumerable()
Where System.Text.RegularExpressions.Regex.IsMatch(row("Appointment Insurance Name").ToString.ToUpper, "\b(MA|MMA|MEDICAID)\b")
Select row).ToList.Count>0,(From row In dtInput.AsEnumerable()
Where System.Text.RegularExpressions.Regex.IsMatch(row("Appointment Insurance Name").ToString.ToUpper, "\b(MA|MMA|MEDICAID)\b")
Select row).CopyToDataTable(),dtInput.Clone)

[Jeeru_venkat_Rao]

Thank you @rashmisingh2695 . Its working fine.