using System;

using ChoETL;

​

public class Program

{

    public static void Main()

    {

        typeof(ChoCSVReader).GetAssemblyVersion().Print();

        "".Print();

​

        string csv = @"OrderNo, OrderName, Street, City, Zip

1, Name1, Main Street, New York, 10010";

​

        var config = new ChoCSVRecordConfiguration<SalesOrder1>()

            .WithFirstLineHeader()

            .Configure(c => c.ThrowAndStopOnMissingField = false)

            .Configure(c => c.IgnoreEmptyLine = true)

            .Configure(c => c.FileHeaderConfiguration.IgnoreColumnsWithEmptyHeader = true);

​

        config.Map(f => f.SalesAddress.Street, "Street");

        config.Map(f => f.SalesAddress.City, "City");

        config.Map(f => f.SalesAddress.Zip, "Zip");

​

        using (var r = ChoCSVReader<SalesOrder1>.LoadText(csv, config)

            .WithFirstLineHeader()

            )

        {

            r.Print();

        }

    }

​

    public class SalesAddress1

    {

        public CustomString Street { get; set; }

        public CustomString City { get; set; }

        public CustomString Zip { get; set; }

    }

​

    public class SalesOrder1

    {

        public string OrderNo { get; set; }

        public string OrderName { get; set; }

        public SalesAddress1 SalesAddress { get; set; }

    }

​

    public struct CustomString

    {

        public string Value { get; }

​

        public CustomString(string val)

        {

            if (string.IsNullOrWhiteSpace(val))

            {

                Value = null;

            }

            else

            {

                Value = val.ToUpper();

            }

        }

​

        public static implicit operator string(CustomString s) => s.Value;

        public static explicit operator CustomString(string s) => new CustomString(s);

        public override string ToString() => Value;

    }

​

}

​

​