using System;

using System.Text.RegularExpressions;

using System.Diagnostics;

using System.Globalization;

using System.Reflection;

public class Program

{

    public static void Main()

    {

        //Console.WriteLine("TESTDATE:"+ testDate); 

        //ARRIVA COSI DAL FOGLIO EXCEL IL FORMATO E' RICONOCIUTO DA EXCEL MA NON DA C#

        string keywords="=Text(\"07/08/2024 05:28:15\",\"mm/dd/yyyy HH:mm:SS\")"; 

        //string keywords="=Text(\"07/08/2024 05:28:15\",\"MM/dd/yyyy hh:mm:ss\")"; //QUESTO LO RICONOSCE c# MM sui mesi MAIUSCOLO e HH deve essere minuscolo e SS deve essere minuscolo

        MatchCollection col = Regex.Matches(keywords, "\\\"(.*?)\\\"");

        //Console.WriteLine("ELEM0:" + col[0].ToString());

        //Console.WriteLine("ELEM1:" + col[1].ToString());

        string dataExpr= col[0].ToString().Replace("\"","");

        string formatExpr=  col[1].ToString().Replace("\"","");

        string[] formatTokenizer= formatExpr.Split(" ");

        string formatTransform= formatTokenizer[0].Replace("mm","MM") + " " + formatTokenizer[1].Replace("HH","hh").Replace("SS","ss");

        Console.WriteLine("DATAEXPR:" +dataExpr.Replace("\"",""));

        Console.WriteLine("FORMATEXPR:" +formatExpr.Replace("\"",""));

        Console.WriteLine("FORMAT_TRANSFORM:"+formatTransform);

        DateTime.TryParseExact(dataExpr, formatTransform, CultureInfo.InvariantCulture,0, out DateTime orarioTlong);

        Console.WriteLine("DATACONVERTED:" + orarioTlong);

        /*foreach(var pippo in col) {

            Console.WriteLine(pippo.ToString());

        }*/

    }

}