CODEWITHSUNDEEP
c#.net-corecsvhelper
Persei
Persei

Reputation: 109

CSV Helper Wraps string field ' Name' into double quotes after delimiter?

I have some troubles with CSV result in my file, I have written the next configuration in code ( I am working with CSVHelper library)

public class ReportModelMap : ClassMap<ReportModel>
{
    public ReportModelMap()
    {
        Map(x => x.Name).Index(9).Name(" Name");
    }
}

The customer requires to add the space between the 'Name' text => " Name". However, the library wraps the string into ' Name' into double quotes, and for me, it's wrong behavior. How can I make --Surname; Name-- instead of --Surname;" Name"--?

I can't find any specific configuration to fix it in CsvWriter

My saving logic if it needed

using (var writer = new StreamWriter(path))
using (var csvWriter = new CsvWriter(writer, CultureInfo.InvariantCulture))
{
   csvWriter.Configuration.RegisterClassMap<ReportModelMap>();
   csvWriter.Configuration.Delimiter = ";";

   csvWriter.WriteRecords(ratingModels);
}

Upvotes: 0

Views: 818

Answers (1)

David Specht
David Specht

Reputation: 9074

@Panagiotis Kanavos is correct. You can use ShouldQuote to override the quoting behavior for just that one heading.

void Main()
{
    var ratingModels = new List<ReportModel>
    {
        new ReportModel { Id = 1, Surname = "Surname", Name = " Name" } 
    };
    
    //using (var writer = new StreamWriter(path))
    using (var csvWriter = new CsvWriter(Console.Out, CultureInfo.InvariantCulture))
    {
        csvWriter.Configuration.RegisterClassMap<ReportModelMap>();
        csvWriter.Configuration.Delimiter = ";";
        csvWriter.Configuration.ShouldQuote = (field, context) => 
        {
            if (!context.HasHeaderBeenWritten && field == " Name") 
            {
                return false;
            } 
            else 
            {
                return ConfigurationFunctions.ShouldQuote(field, context); 
            }
        };

        csvWriter.WriteRecords(ratingModels);
    }
}

// You can define other methods, fields, classes and namespaces here
public class ReportModelMap : ClassMap<ReportModel>
{
    public ReportModelMap()
    {
        Map(x => x.Id).Index(0);
        Map(x => x.Surname).Index(1);
        Map(x => x.Name).Index(2).Name(" Name");
    }
}

public class ReportModel
{   
    public int Id { get; set; }
    public string Surname { get; set; }
    public string Name { get; set; }
}

Upvotes: 1

Related Questions