static void Main(string[] args) { ConvertToNestedObjects(); return; //System.Threading.Thread.CurrentThread.CurrentCulture = new CultureInfo("it"); //using (var p = new ChoCSVReader("Bosch Luglio 2017.csv") // .Configure((c) => c.MayContainEOLInData = true) //Handle newline chars in data // .Configure(c => c.Encoding = Encoding.GetEncoding("iso-8859-1")) //Specify the encoding for reading // .WithField("CodArt", 1) //first column // .WithField("Descrizione", 2) //second column // .WithField("Prezzo", 3, fieldType: typeof(decimal)) //third column // .Setup(c => c.BeforeRecordLoad += (o, e) => // { // e.Source = e.Source.CastTo<string>().Replace(@"""", String.Empty); //Remove the quotes // }) //Scrub the data // ) //{ // //var dt = p.AsDataTable(); // foreach (var rec in p) // Console.WriteLine(rec.Prezzo); //} //return; //using (var parser = new ChoCSVReader("Dict1.csv") // .WithField("AR_ID", 7) // .WithField("AR_TYPE", 8) // .WithFirstLineHeader(true) // .Configure(c => c.IgnoreEmptyLine = true) // ) //{ // var dict = parser.ToDictionary(item => item.AR_ID, item => item.AR_TYPE); // foreach (var kvp in dict) // Console.WriteLine(kvp.Key + " " + kvp.Value); //} //return; //return; using (var parser = new ChoCSVReader("IgnoreLineFile1.csv") .WithField("PolicyNumber", 1) .WithField("VinNumber", 2) .Configure(c => c.IgnoreEmptyLine = true) .Configure(c => c.ColumnCountStrict = true) ) { using (var writer = new ChoJSONWriter("ignoreLineFile1.json") .WithField("PolicyNumber", fieldName: "Policy Number") .WithField("VinNumber", fieldName: "Vin Number") ) writer.Write(parser.Skip(1)); } return; //foreach (dynamic rec in new ChoCSVReader("emp.csv").WithFirstLineHeader() // .WithFields(" id ", "Name") // .Configure(c => c.FileHeaderConfiguration.IgnoreCase = false) // .Configure(c => c.FileHeaderConfiguration.TrimOption = ChoFieldValueTrimOption.None) // .Configure(c => c.ThrowAndStopOnMissingField = true) // //.Configure(c => c.ColumnOrderStrict = false) // ) //{ // Console.WriteLine(rec.id); // //Console.WriteLine(rec[" id "]); //} //return; //foreach (var rec in new ChoCSVReader<EmployeeRec>("emp.csv") // .Configure(c => c.FileHeaderConfiguration.IgnoreCase = false) // .Configure(c => c.ThrowAndStopOnMissingField = true) // ) //{ // Console.WriteLine(rec.Id); //} //return; //Set the culture, if your system different from the file type //HierarchyCSV(); //return; foreach (dynamic rec in new ChoCSVReader("CurrencyQuotes.csv").WithDelimiter(";") .WithField("F1", 14, fieldType: typeof(int)) .WithField("F2", 15, fieldType: typeof(int)) .WithField("F3", 16, fieldType: typeof(int)) .Configure(c => c.ErrorMode = ChoErrorMode.ReportAndContinue) ) { Console.WriteLine("{0}", rec.F1); } return; //string txt = @"ZipCode SortCode 3rd "; //foreach (var x2 in txt.Split(" ", ChoStringSplitOptions.All, '"')) // Console.WriteLine(x2); //return; CultureSpecificDateTimeTest(); return; var x = 1; //Console.WriteLine(@_2); ////var identifierRegex = new System.Text.RegularExpressions.Regex(@"(?<=^| )(?!\d)\w+|(?<= )(?!\d)\w+(?= |$)"); ////Console.WriteLine(Regex.Replace("1sas3", @"(?<=^| )(?!\d)\w+|(?<= )(?!\d)\w+(?= |$)", "_")); ////return; //var i = Microsoft.CSharp.CSharpCodeProvider.CreateProvider("C#").CreateValidIdentifier("@Main 12"); //Console.WriteLine(i.ToValidVariableName()); //return; QuotedCSVTest(); }