Remove time from calendar schedule string

[mj.work]

I have this text that I extracted from outlook “Saturday, October 14, 2023 8:00 AM-9:00 AM”

What’s the best way to dynamically remove the time so that it’ll just be “Saturday, October 14, 2023”?

[Gokul001 (Gokul Balaji)]

Hi @mj.work

You can try with Regular expression

System.Text.RegularExpressions.Regex.Match(YourString,"\S+,\s\S+\s[0-9]+").Tostring

[Yoichi]

Hi,

How about the following expression?

System.Text.RegularExpressions.Regex.Replace(yourString,"(?<=\d{4}).*","")

regards,

[Anil_G (Anil Gorthi)]

@mj.work

Please try this

\w+, \w+ \d+, \d+

System.Text.RegularExpressions.Regex.Match(str,"\w+, \w+ \d+, \d+").Value

cheers

[Sudharsan_Ka]

Hi @mj.work

Checkout this

System.Text.RegularExpressions.Regex.Match(INputString,"(.*?)\d{4}").Tostring

Regards
Sudharsan

[mj.work]

Is there a way to remove Saturday to get “October 14, 2023”?

[Sudharsan_Ka]

Check with this @mj.work

System.Text.RegularExpressions.Regex.Match(INputString,"(?m)(?<=\,)(.*?)\d{4}").Tostring.Trim

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @mj.work

Check out the Regular expression

System.Text.RegularExpressions.Regex.Match(INputString,"\S+\s\d{2}\W\s\d{4}").Tostring.Trim

[sasi_poosarla (sasi p)]

@mj.work

System.Text.RegularExpressions.Regex.Match(str,“[a-zA-Z]+\s\d{2}.\s\w+\d{2}”).Value