Excel Column Data is greater than specific value

Help Activities
1

IMG_20211101_151356
IMG_20211101_1513561846×4000 1.37 MB

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

2

@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

3

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

4

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:

grafik
grafik707×346 46.6 KB

Ensure following:
grafik

5

Thanks for the response…!!

Is there any other approach rather than linq…??

Thanks,
Rishi

6

which approaches you would prefer?

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

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

Thanks
Rishi