Extract only Month and Date from string

Sathish_Kumar_S · January 5, 2023, 9:20am

Hi Team,

How to extract only Month and date from below string

Nov 15 09:07 ms_acl_info

Oct 29 00:31 reginfo

Oct 29 00:32 secinfo

Sudharsan_Ka · January 5, 2023, 9:36am

Checkout this expression

System.Text.RegularExpressions.Regex.Match("Your String","^[a-zA-Z]+\s\d+").Tostring

Regards
Sudharsan

Gangadhar_Athili · January 5, 2023, 9:38am

String.Join(" “,“Nov 15 09:07 ms_acl_info”.Split({” "},3,StringSplitOptions.None).Take(2))
“Nov 15”

Gokul_Jayakumar · January 5, 2023, 9:41am

Hello @Sathish_Kumar_S
Try the below regex expression

System.Text.RegularExpressions.Regex.Match("Your String",".*(?=\d\d:\d\d)").Tostring.Trim

ashvani.kumar · January 5, 2023, 9:51am

Hi Satish Kumar

Can you share in which format do you need the Month and date i.e. dd/MM/yyyy?

ashvani.kumar · January 5, 2023, 9:57am

Hi @Sathish_Kumar_S
To Get the output in dd/MM/yyyy. Kindly use the given expression in assign activity against a string type of variable-

Str_date = DateTime.ParseExact(“Nov 15 09:07”,“MMM dd HH:mm”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)