using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Text.RegularExpressions;

using System.IO;

using System.Data;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

​

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

​

using CsvHelper;

using CsvHelper.Configuration;

using CsvHelper.Configuration.Attributes;

using CsvHelper.Expressions;

using CsvHelper.TypeConversion;

​

//https://stackoverflow.com/questions/75985677/how-do-i-preserve-unescaped-double-quotes-in-tsv-data

​

using Newtonsoft.Json;

​

    public class Model

    {

        public string Column1 { get; set; }

        public string Column2 { get; set; }

        public string Column3 { get; set; }

    }

​

    class TestClass

    {

        public static void Test()

        {

            var records = new List<Model>

            {

                { new () { Column1 = "Value \"1\"", Column2 = "Value \"2\"", Column3 = "Value \"3\"" } },

            };

            var config = new CsvConfiguration(CultureInfo.InvariantCulture)

            {

                HasHeaderRecord = true,

                Delimiter = "\t", // FIXED

                NewLine = "\r\n", // FIXED

                IgnoreBlankLines = true,

                MissingFieldFound = null,

                HeaderValidated = null,

                CacheFields = true,

                PrepareHeaderForMatch = args => args.Header.Trim(),

                TrimOptions = TrimOptions.Trim,

                LineBreakInQuotedFieldIsBadData = false,

                Mode = CsvMode.NoEscape // ADDED

            };

            using var writer = new StringWriter();

            using (var csv = new CsvWriter(writer, config))

            {

                csv.WriteRecords(records);

            }           

​

            Console.WriteLine(writer);

        }   

    }

​

    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, JsonConvert.SerializeObject(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;

            }

        }

    }

​