A Simple CSV Parser that is meant to convert csv files into lists of objects.

• Delimited file parsing
• Conversion into usable C# objects
• Binding to headers
• Large file processing

    Install-Package SimpleCsvParser.Core

    dotnet add package SimpleCsvParser.Core

    paket add SimpleCsvParser.Core

The The delimiter that is used to seperate data values.

The wrapper tag that is used if the delimiter exists in the data of the column.

The row delimiter that is used to parse the different rows.

Determine if the parser should remove empty entries from the list before using them.

The starting row the data should start in

The The delimiter that is used to seperate data values.

The wrapper tag that is used if the delimiter exists in the data of the column.

The row delimiter that is used to parse the different rows.

Determine if the parser should remove empty entries from the list before using them.

The starting row the data should start in

Determine if the parser should handle the first line in the delimited stream as a header.

This is shorthand to not worry about creating the stream reader.

    public class TestModel
    {
        [CsvProperty("name")]
        public string Name { get; set; }
        [CsvProperty("type")]
        public TestType Type { get; set; }
        [CsvProperty("cost")]
        public int Cost { get; set; }
        [CsvProperty("id")]
        public int Id { get; set; }
    }

    public enum TestType
    {
        Attachment,
        Effect,
        Spell,
        Structure
    }

    ...
    var list = CsvParser.ParseFile<TestModel>("test.csv", new CsvStreamReaderWithHeaderOptions() { RemoveEmptyEntries = true, StartRow = 1 });
    // List<TestModel>
    //      { Name = "Claws", Type = TestType.Attachment, Cost = 10, Id = 1 }
    //      { Name = "Double Edge Sword", Type = TestType.Attachment, Cost = 10, Id = 2 }
    //      { Name = "Gauntlet", Type = TestType.Attachment, Cost = 10, Id = 3 }
    //      { Name = "Leather Armour", Type = TestType.Attachment, Cost = 15, Id = 4 }
    //      ...
    ...

test.csv

name,type,cost,id,final
Claws,Attachment,10,"1",
Double Edge Sword,Attachment,10,2,
Gauntlet,Attachment,10,3,"Final, Test"
Leather Armour,Attachment,15,4,
Wings,Attachment,15,5,
Control,Effect,10,6,
,,,,
Ensnare,Effect,15,7,
Healing Spring,Effect,15,8,
Katee's Inferno,Effect,20,9,
Tornado,Effect,25,10,
Destroy Attachment,Spell,10,11,
Fireball,Spell,5,12,
,,,,
Heal,Spell,5,13,
Lightning Bolt,Spell,10,14,
Teleport,Spell,10,15,
Armory,Structure,15,16,
Blacksmith,Structure,15,17,
"""Magma"" Fissure",Structure,15,18,
"Medical,Healing Camp",Structure,15,19,
Spire,Structure,5,20,
,,,,
,,,,

Basic Usage for stream objects

    using var reader = new CsvStreamModelReader<TestModel>(stream);
    reader.LoadHeaders();
    foreach (var item in reader.Parse())
    {
        ... Do stuff with item
    }

• CsvStreamModelReader
  • A standard reader that will mainly used by this framework to build out objects from the delimited data.
• CsvStreamReader
  • A basic stream reader that parses a 2D list of items

All notable changes to this project will be added here until it gets to long and a file is needed.

• Minor bug fix where buffer was being saved even when the data being parsed needs to skip a few rows

• Minor speed increases
• Fixed issue with large files where delimiters were not being handled correctly

• Minor speed increases
• All for null or empty delimiters

• A major overhaul has been done, thus the major version release.
  • Speed improvements have been included into this version
  • Less memory usage by the main processor
  • Writing is no long support but may revist it later once the speed has been improved more

• Bug Fix: Fixing an issue when trying to use CsvDictionaryStreamReader when ParseHeaders is false, now will create a dictionary based on the empty lamda function passed into the AsEnumerable for this stream.

• Bug Fix: Changed ToDictionary Stream to deal with seperating items better.

• Change Allow for null to be passed to the Wrapper option.

• Moved Streams into the 'SimpleCsvParser.Streams' namespace.
• Added: CsvRowStreamReader to allow for custom parsers.

• The main purpose of these changes is to allow for parsing on files where the header names are unknown until it is parsed, and Dictionary is how it is done.
• Reworked internals so that dictionaries could be used.
• Added new options: All delimiters got changed from char to string.
  • HeaderRowDelimiter: The header row delimiter should be used.
  • HeaderDelimiter: The header delimiter that should be used.
  • HeaderRow: The index where the header should start when the row delimiter is applied.
  • DataRow: The index where the data should start when the row delimiter is applied.
• Added CsvDictionaryStreamReader to deal with reading dictionary results that do not have all their headers defined.
• Malformed Exception is not thrown or row parsing now due to the data could have comments and the DataRow/HeaderRow gives more control to skip these rows.

• Reworked data streams to allow for better parallelization and enumeration.
• Added AsParallel to the reader to handle large file processing.
• Various speed improvements.

• Reworked the data stream to build out the rows and columns.
• Added in new option (RowDelimiter) which will allow for different row types.
  • This is a change that could break the previous version because before it was checking for '\r', '\n' and '\r\n' all at once. And now is only checking for '\r\n' or whatever is in the RowDelimiter option.
• Adding in the CsvStreamWriter this will allow for the writing of objects to a file or stream.
• Various speed impovements.
• Added in new option (WriteHeaders) which will handle if the parser needs to print the headers to the file or stream.

SimpleCsvParser.Core is licensed under the Microsoft Public License