Excel Column Data is greater than specific value

Hi,

I have an excel file where one column name is “Age” and have the data which is present in attached Screenshot…!!

So I need to get the data which Age is greater than 2days…!!

Any help it would be appreciated…!!

Thanks,
Rishi

@Rishik_Chowdary

Use Filter Datatable where the Age is Not Equal to 2 days

But also we need to ask that Is there any formula generating this in words?

Thanks

Thanks for ur reply…!!

Already the data was in queue…!! So taking IF condition what I need to write the syntax…? If it is 2days higher so I can drop a mail…!!

Thanks,
Rishi

Give a try on a LINQ

Assign Activity:
LHS: dtFiltered | DataType: DataTable
RHS:

From d in dtData.AsEnumerable
Let sn = Regex.Match(d(YourColNameOrIndex).toString.Trim, "\d+ (?=days)").toString
Let no = Cint(sn.trim)
Where no > 2
Select r=d).CopyToDataTable

Empty filter results we do handle with following:

Ensure following:
grafik

Thanks for the response…!!

Is there any other approach rather than linq…??

Thanks,
Rishi

which approaches you would prefer?

  • filter datatable
  • datatable.Select Method
  • redundant reimplementing filterings with for each row and if acitvities
  • working with helper columns

Datatable.select or else If condition is fine…!!

Thanks
Rishi