using System;

using ChoETL;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        PrintLibVersion();

​

        string csv = @"Id, Name, City

1, Tom, {NULL}

2, Mark, NJ

3, Lou, FL

4, Smith, PA

5, Raj, DC

";

        using (var r = ChoCSVReader.LoadText(csv)

               .WithFirstLineHeader()

               //.Configure(c => c.NullValue = "{NULL}")

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

              )

        {

            r.Select(rec => 

                     {

                         if (rec.City.Trim() == "{NULL}")

                             rec.City = null;

                         return rec; 

                     }).Print();

        }

    }

    static void PrintLibVersion()

    {

        $"ChoETL.JSON.NETStandard v.{typeof(ChoJSONReader).Assembly.GetName().Version.ToString()}".Print();

        "".Print();

    }   

}