Filter the Dates from Column

Help Activities
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