Hello, I have this Excel column as shown below. I need to extract only the date found at the end of it and paste it into a new column next to it: [image] [image] Can someone help me please? thanks! UIPath_Excel_Scratch (1).xlsx (131.9 KB)

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/…

@Yudhisteer_Chintaram1 Read your data table using read range and iterate through for each row. 2.inside for each row assign your row value, InvDate=row(0).Tostring 3.Then assign Date= System.Text.RegularExpressions.Regex.Match(InvDate,“(0?[1-9]|1[0-2]) / / \d{2}”).ToString it will gives you date …

Simply Use Split(Split(readtext,“;”)(1).ToString," / ")(1).ToString.Trim Note the two spaces around the / in [" / ")(1)] That should give you the date

Thanks for the help :slight_smile:

Hi @prasath_S , Can you help in this one please? [image] Write full Date Format in Excel column Activities Hi, I have this Date Column as shown below: [image] I want to change it to full sentence format as such: [image] So these are the months and how it should be …

Excel Regex Extract Date

Help Activities

Yudhisteer_Chintaram1 (Yudhisteer Chintaram) May 5, 2021, 9:21am 7

Hi @prasath_S ,
Can you help in this one please?

Topic		Replies	Views
Excel Convert Row Value into Date Format Help datatable , excel	10	2578	September 22, 2019
Get the column from excel and convert to date formate Help	2	1199	October 24, 2019
Remove string and convert the remaining text to date Activities uiautomation , activities , question	6	1131	December 26, 2022
Click massive Excel cells Studio studio , question , workflow_diff	6	816	December 30, 2022
How to Extract Date from excel file Studio studio , question , workflow_diff	20	1357	November 8, 2022

Excel Regex Extract Date

Related topics