FIlter only those data which is having .00 in last

[Puneet_Singh1 (Puneet Singh)]

Hi,

I want to filter only that data which is having .00 in last like 1800.00
See screenshot. I want to filter only highlighted data. Highlighted data having .00 in last. All this data is in datatable.

[Yoichi]

Hi,

if possible, can you share the sample as file?

Regards,

[Puneet_Singh1 (Puneet Singh)]

Stock Filter.xlsx (9.1 KB)

[mkankatala (Mahesh Kankatala)]

Hi @Puneet_Singh1

→ Use the Read Range workbook activity to read the excel and store in a datatable called Input_dt.
→ Then take an assign activity and write the below linQ Expression to filter the data,

- Assign -> Filtered_dt = (From row in Input_dt
                           where row(2).toString.contains(".00")
                           Select row
                                 ).Copytodatatable

→ Then use Write range workbook activity to write the Filtered_dt to the new sheet in the excel.

Hope it helps!!

[Yoichi]

Hi

Thank you for sharing.
Can you also share why you need .00 data?
I checked your data and .00 is displayed by format settings.

So, it’s no difference b/w 391 and 6,078.00 except format setting.

Regards,