extract date part only from a English sentence

Question

How to extract date part only from a English sentence.
Some scenario

Is there is any holiday on 19-02-2012
Is there is any holiday on 19/02/2012
Is there is any holiday on 19.02.2012
Is there is any holiday on 2012/02/19
Is there is any holiday on 02-19-2012
Is there is any holiday on 19th feb 2017
Is There is any holiday on 19th-feb-2017
Is There is any holiday on Feb 19 2017
Is There is any holiday on 19th/feb/2017
Is There is any holiday on 19 Feb
Is There is any holiday on Feb 19

For these all sentences expected output should be in Date format
Day - 19
Month - 02
Year -2017

Dharmraj Thakur · Answer

Just declare your all formats like this and split the string then read the date.... class Tester { static void Main( string [] args) { string [] formats= { M/d/yyyy h:mm:ss tt  M/d/yyyy h:mm tt  MM-dd-yyyy  M/d/yyyy h:mm:ss  M/d/yyyy hh:mm tt  M/d/yyyy hh tt  M/d/yyyy h:mm  M/d/yyyy h:mm  MM/dd/yyyy hh:mm  M/dd/yyyy hh:mm }; string allString= Is there is any holiday on 19-02-2012 Is there is any holiday on 19/02/2012 Is there is any holiday on 19.02.2012 Is there is any holiday on 2012/02/19 Is there is any holiday on 02-19-2012 Is there is any holiday on 19th feb 2017 Is There is any holiday on 19th-feb-2017 Is There is any holiday on Feb 19 2017 Is There is any holiday on 19th/feb/2017 Is There is any holiday on 19 Feb Is There is any holiday on Feb 19 ; string [] dateStrings = allString.Split( ' ' ); DateTime dateValue; foreach ( string dateString in dateStrings) { if (DateTime.TryParseExact(dateString formats new CultureInfo( en-US ) DateTimeStyles.None out dateValue)) Console.WriteLine( Converted '{0}' to {1}.  dateString dateValue); else Console.WriteLine( Unable to convert '{0}' to a date.  dateString); } Console.ReadKey(); } }

Amit Gupta · Answer

Before getting into the result just want to aware you that as you have multiple date formats dd/Mm/yyyy Mm/dd/yyyy etc it will show according to localization of your PC. var data = Is there is any holiday on 19-02-2012 ; // we have to remove th else it gives exception var result = data.Substring (data.LastIndexOf ( on )+1).Replace ( th   ).Replace (  -); var dt = Convert.ToDateTime (result); // now extract dd mm yyyy accordingly var dd = dt.ToString ( dd ); var mm = dt.ToString ( MM ); var year = dt.ToString ( yyyy );

sudheer tiwari · Answer

Thanks Amit & Panna It's nogt suitable for all format

panna chatterjee · Answer

public static void Main(string[] args) { String s = Is There is any holiday on 19-02-2012; string DateExtract = s.Substring((s.IndexOf(on) + 3) s.Length - (s.IndexOf(on) + 3)); var result = DateExtract.Split('/' '-'' ''''.'':'); Console.WriteLine(
 Day-{0} 
 Month-{1} 
 Year-{2} 
 result[0] result[1] result[2]); //Console.Read(); }