TxtCsvHelper 1.1.6

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.7

Usage

using TxtCsvHelper;

//To return an IEnumerable<T> //Parser can take a Stream, ReadStream(acts like StreamReader), 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) //Deserialize takes a type of a class (model) using(Parser p = new Parser(postedFile.OpenReadStream(), ',', true, false) { IEnumerable<Name> models = p.Deserialize<Name>(); }

//To return an IEnumerable of type dynamic //Parser can take a Stream, ReadStream(acts like StreamReader), 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 but needs to be true for dynamic types) //A bool if there are spaces between delimiters and fields (will default to false)

using(Parser p = new Parser(postedFile.OpenReadStream(), ',', true, false) { var models = p.Deserialize(); }

//To return an IEnumerable<string> for each line //ReadStream acts exactly like StreamReader //Parser in this case takes 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) //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())) using(Parser p = new Parser()) { while(rs.Peek() >= 0) IEnumerable<string> substrings = p.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; } }