using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

using System.Dynamic;

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

​

using CsvHelper;

using CsvHelper.Configuration;

using CsvHelper.Configuration.Attributes;

using CsvHelper.Expressions;

using CsvHelper.TypeConversion;

​

//using Newtonsoft.Json;

​

#nullable enable

​

//https://stackoverflow.com/questions/77275817/dotnet-csvhelper-rfc4180-mode-escape-double-quote

​

    class TestClass

    {

        public static void Test()

        {

            var csvString = GetCsv();

            var objectList = new List<dynamic>();

            var parserConfig = new CsvConfiguration(CultureInfo.InvariantCulture)

            {

                Delimiter = "¦", // fileMap.Delimiter,

                HasHeaderRecord = false, // hasHeader -- true or false?

                Mode = CsvMode.RFC4180,

                Escape = '\\', // EscapeCharacter

            };          

            using (var reader = new StringReader(csvString))

            using (var csv = new CsvReader(reader, parserConfig))

            {

                  while (csv.Read())

                  {

                    dynamic objectRecords = new ExpandoObject();

                    var iterator = 0;

                    while (csv.TryGetField(iterator, out string? field))

                    {

                      ((IDictionary<string, object>)objectRecords).Add(iterator.ToString(), field);

                      iterator++;

                        Console.WriteLine(field);

                    }

                    objectList.Add(objectRecords);

              }

            }

        }

        static string GetCsv() =>

"""

12.0000¦6.11000¦LB¦9189AD510001¦Photo Insert 5\" x 5\"Iron¦¦¦23.00¦13.50¦5.00¦IN¦1726.31250¦

""";            

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1}), {2}.", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , Environment.Version, Environment.OSVersion);

            Console.WriteLine("OS Version: {0}, NewLine: {1}", System.Environment.OSVersion, System.Text.Json.JsonSerializer.Serialize(Environment.NewLine));

            Console.WriteLine("{0} version: {1}", typeof(CsvReader).Assembly.GetName().Name,  typeof(CsvReader).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

    }

​