{"id":893,"date":"2016-01-24T13:50:19","date_gmt":"2016-01-24T03:50:19","guid":{"rendered":"http:\/\/www.moneystock.net\/wp_e\/?p=893"},"modified":"2016-01-24T14:27:37","modified_gmt":"2016-01-24T04:27:37","slug":"csv-library-to-use","status":"publish","type":"post","link":"https:\/\/moneystock.net\/wp_e\/2016\/01\/24\/csv-library-to-use\/","title":{"rendered":"CSV Library to use"},"content":{"rendered":"

At first, I used custom built CSV helper class, which simply separates CSV formatted string with a comma and push the data into DataTable. However, this class didn’t handle double quotation qualifier well enough.<\/p>\n

So, I started searching for a CSV library.<\/p>\n

One reliable and mostly recommended CSV library was A Fast CSV Reader<\/a>\u00a0(aka\u00a0LumenWorks.Framework.IO<\/a>)\u00a0by\u00a0Sebastien Lorion<\/a>, but it’s not maintained by\u00a0Paul Hatcher in Github Repo<\/a>\u00a0in the name of CsvReader.<\/p>\n

The CsvReader<\/a> library is an extended version of Sebastian Lorien’s fast CSV Reader<\/a> project and provides fast parsing and reading of CSV files<\/p>\n

by –\u00a0Paul Hatcher<\/p><\/blockquote>\n

This was quite good, until I found<\/p>\n

    \n
  1. CsvReader does not returns the correct row there the CSV format is broken<\/li>\n
  2. When there is CR\/LF in the middle of CSV data, this library cannot handle it even though the CR\/LR is wrapped by double quotation qualifier.<\/li>\n<\/ol>\n

    The next one I’ve chosen is\u00a0DataStreams framework<\/a>, which can cope with CR\/LF in CSV data. Unfortunately, this isn’t open-source. \u00a0I’m happy with DataStreams up until now.<\/p>\n

    Hope to find open source CSV libary that is as stable as DataStreams.<\/p>\n

    Still, I’m using my first CSVHelper class as a facade \/ wrapper class for these 3rd party library so as to separate the concern as we normally do.<\/p>\n","protected":false},"excerpt":{"rendered":"

    At first, I used custom built CSV helper class, which simply separates CSV formatted string with a comma and push the data into DataTable. However, this class didn’t handle double quotation qualifier well enough. So, I started searching for a CSV library. One reliable and mostly recommended CSV library was A Fast CSV Reader\u00a0(aka\u00a0LumenWorks.Framework.IO)\u00a0by\u00a0Sebastien Lorion,… Continue reading CSV Library to use<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[203],"tags":[184,95,204,205,208,207,206],"class_list":["post-893","post","type-post","status-publish","format-standard","hentry","category-library","tag-net","tag-c","tag-csv","tag-csv-reader","tag-datastreams","tag-paul-hatcher","tag-sebastien-lorion","entry"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t