Remove string and convert the remaining text to date

[Botter]

Hi, I guess this is a very simple ting, but I still manage to get stuck. In col 0 in a datatable, each row has a string similar to this:

Tuesday, 14-MAY-2022 (All text)

I need to delete everything before the date part, and then convert the text formatted date to a real date.

Anyone?

[Gokul001 (Gokul Balaji)]

@Botter

Tuesday, 14-MAY-2022 (All text)

Hi @Botter

You can try with Regex expression

System.Text.RegularExpressions.Regex.Match(Currentrow("ColumnName").Tostring,"\d{2}-\S.*-\d{4}").Tostring

Check out this tutorial and thread for chamging the date format in excel file

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Date and month interchanged while reading from excel

HI @Jayesh_Rathi1 How about this expression? DateTime.ParseExact(CurrentRow("Column Name").ToString.Trim,"MM-dd-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Note : dd-MM-yyyy -> Based on excel date fomat Or You can try to change the format of the column Excel process scope activity Use excel file activity Format cell activity [image] Regards Gokul

Regards
Gokul

[Umadevi_Sanjeevi]

@Botter

14-MAY-2022

Hi @Botter ,

Can you try this,

str = Tuesday, 14-MAY-2022

dateTimeVar = DateTime.ParseExact(str.Split(","c)(1),“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture)

[Gokul001 (Gokul Balaji)]

Hi @Botter

Alternative Method, It will gives you only the date.

DateTime.ParseExact(Currentrow("ColumnName").Tostring,"dddd, dd-MMM-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Regards
Gokul

[Botter]

@Gokul001

DateTime.ParseExact(Currentrow("ColumnName").Tostring,"dddd, dd-MMM-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

And this I should use in a “For Each Row In Data Table” activity?

[Gokul001 (Gokul Balaji)]

@Botter

I should use in a “For Each Row In Data Table” activity?

Yes, You need to use For each row in Data Table activity

[Botter]

OK, thank you very much for your time and sharing your knowledge all of you!