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();
}