Filter the Dates from Column

Help Activities
1

hello everyone i have one requirement

Forum_filter

from Date column i want to pick only dates and string will be neglected
thanks in advance

2

Hi @dheerandra.vishwakarma

→ Use the Read range workbook activity to read the excel and store in a datatable called dt_Input.
→ Then take an assign activity, and you can use LINQ Expression,

- Assign -> dt_Output = (From row In dt_Input.AsEnumerable()
                         Where System.Text.RegularExpressions.Regex.IsMatch(row("Date").ToString(), "\d+/\d+/\d+")
                         Select row).CopyToDataTable()

→ Then use the Write range workbook activity to write the dt_Output to excel.

Hope it helps!!

1 Like
3

@mkankatala
Thanks for your help :slightly_smiling_face:

1 Like
4

It’s my pleasure… @dheerandra.vishwakarma

Happy Automation!!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.