using System;

using System.IO;

using System.Globalization;

​

using System.Collections.Generic;

using System.Linq;

​

using Newtonsoft.Json;

​

using System.Xml;

using System.Xml.Linq;

​

using CsvHelper;

using CsvHelper.Configuration;

​

public class Program

{ 

    public static void Main()

    {

        string input = @"MECMD4VL2X426,ME,Memory,DDR-4 (Desktop),Corsair Vengeance LPX 8GB (2x4GB) DDR4 2666MHz C16 Desktop Gaming Memory Black,""Corsair 8GB (2x4GB) DDR4 2666MHz Vengeance LPX Black

​

Designed for high-performance overclocking on Intel X99 and 100 Series motherboards

​

Vengeance LPX memory is designed for high-performance overclocking. The heatspreader is made of pure aluminum for faster heat dissipation\, and the eight-layer PCB helps manage heat and provides superior overclocking headroom. Each IC is individually screened for performance potential.

​

The DDR4 form factor is optimized for the latest Intel X99 and 100 Series motherboards and offers higher frequencies, greater bandwidth\, and lower power consumption than DDR3 modules. Vengeance LPX DDR4 modules are compatibility-tested across X99 and 100 Series motherboards for reliably fast performance. There’s XMP 2.0 support for trouble-free automatic overclocking. And\, they’re available in multiple colors to match your motherboard, your components, or just your style.

​

Designed for Enthusiasts. Backed by Corsair.

​

World-famous reliability and performance

There's a reason why world-champion overclockers, extreme gaming enthusiasts and high-end system builders all trust Corsair for high-performance memory that they can install with confidence and pride. Whether you're breaking your own records or you're simply building a dream gaming rig, you can count on Corsair memory.

​

Lifetime limited warranty

Your performance investment is protected. All of our memory products are backed by a limited lifetime warranty.

​

The Corsair Advantage

With a long history of building enthusiast-grade memory and components, we've earned a reputation for quality, compatibility, and performance."",8.43591E+11,72,95,https://www.leadersystems.com.au/Images/MECMD4VL2X426.jpg,Corsair,CMK8GX4M2A2666C16,0.12,155,90,100,120,CALL,CALL,CALL,CALL,CALL,CALL

";

        var records = new List<Leader>();

        using (var reader = new StringReader(input))

        using (var csvReader = new CsvReader(reader,  CultureInfo.InvariantCulture ))

        {       

            csvReader.Configuration.HasHeaderRecord = false;

            csvReader.Configuration.RegisterClassMap<LeaderMap>();

            records = csvReader.GetRecords<Leader>().ToList();

        }

        records.Dump();

    }

    public class Leader

    {       

        public string LongColumn6 { get; set; } // not need just to show how it work

        public string Supplier { get; set; }

        public string Category { get; set; }

        public string StockCode { get; set; }

        public string Cost { get; set; }

        public string Description { get; set; }

        public string Image { get; set; }

        public string Manufacturer { get; set; }

        public string Sell { get; set; }

        public string StockAdelaide { get; set; }

        public string StockBrisbane { get; set; }

        public string StockMelbourne { get; set; }

        public string StockPerth { get; set; }

        public string StockSydney { get; set; }

        public string Subcategory { get; set; }

    }

​

    public sealed class LeaderMap : ClassMap<Leader>

    {

        public LeaderMap()

        {

            // the column that cause the issue

            // we don't need to map it cause we don't need it in the first place 

            // But for the sake of the example we are going to get the data from this field.

            Map(m => m.LongColumn6).Index(5); 

​

            //complete the List

            Map(m => m.Category).Index(2);

            Map(m => m.StockCode).Index(11);

            Map(m => m.Cost).Index(7);

            Map(m => m.Description).Index(4);

        }

    }

​

}