TxtCsvHelper 1.1.1

TxtCsvHelper

TxtCsvHelper is a library to assist in parsing CSV, or any other form of delimited files. You can fill models, fill dynamics, or simply get a list of fields by line.

Installation

Use the package manager console to install TxtCsvHelper.

Install-Package TxtCsvHelper -Version 1.1.1

Usage

using TxtCsvHelper;

//To return an IEnumerable<T> //Deserialize<T> can take a Stream, FileStream, MemoryStream or a string //Followed by 3 optional parameters: the delimiter character (will default to a comma) //A bool if there is a header line (will default to true) //A bool if there are spaces between delimiters and fields (will default to false)

var models = Parser.Deserialize<Name>(postedFile.OpenReadStream(), ',', true, false);

//To return an IEnumerable of type dynamic //Deserialize can take a Stream, FileStream, MemoryStream or a string //Followed by 2 optional parameters: the delimiter character (will default to a comma) //A bool if there are spaces between delimiters and fields (will default to false)

var models = Parser.Deserialize(postedFile.OpenReadStream(), ',', false);

//To return an IEnumerable<string> for each //line //SplitLine takes a Line of delimited fields //Followed by 2 optional parameters: the //delimiter character (will default to a comma) //A bool if there are spaces between delimiters //and fields (will default to false)

(using (ReadStream rs = new ReadStream(postedFile.OpenReadStream())) { while(rs.Peek() >= 0) IEnumerable<string> substrings = Parser.Splitline(rs.Readline()); //do something with the strings }

//If no header exists, you may declare the index of the field in the model with [SetIndex()] //simply put the index starting with 0 inside the parentheses

using TxtCsvHelper; public class Name { [SetIndex(1)] public string LastName { get; set; } [SetIndex(0)] public string FirstName { get; set; } [SetIndex(2)] public string MiddleName { get; set; } [SetIndex(3)] public int Age { get; set; } }