Excel Regex Extract Date

Hi @Yudhisteer_Chintaram1

Please try this Main.xaml (9.2 KB)

In Invoke Code

dt1.AsEnumerable().ToList().foreach(sub(row) row(“Date”) = System.Text.RegularExpressions.Regex.Matches(row(“INV Date / BL Date”).ToString,“\d{1,2}/\d{1,2}/\d{1,4}”,RegexOptions.RightToLeft)(0))

Pass you datatable as in/out argument

image

Use write range to check if values are correct

Thanks

3 Likes