Cinchoo ETL
DRANK

1. IntroductionChoETL is an open source ETL (extract, transform and load) framework for .NET. It is a code based library for extracting data from multiple sources, transforming, and loading into your very own data warehouse in .NET environment. You can have data in your data warehouse in no time.This article talks about sorting large CSV files using ChoCSVReader/ChoCSVWriter components offered by ChoETL framework. Large CSV files present a challenge when need arises to sort. It fails with OutOfMemory exception if you try to do with .NET application. With Microsoft Excel for sorting on large files, you will promptly receive an error at first time.If a string sort will work for you, then just use the Windows SORT command. Sort the file and be done with it. It'll happily sort your large CSV file, and it's simple to use.If you need to filter and convert the file, specifically the date / custom type fields, then you would need to write a small conversion program that converts the fields wh…

codeproject.com
Related Topics: SQLite Excel
13 comments
  • Hey, I am so thrilled I found your blog, I am here now and could just like to say thank for a tremendous post and all round interesting website. Please do keep up the great work. I cannot be without visiting your blog again and again. mawartoto

  • If more people that write articles really concerned themselves with writing great content like you, more readers would be interested in their writings. Thank you for caring about your content. apollo tv If more people that write articles really concerned themselves with writing great content like you, more readers would be interested in their writings. Thank you for caring about your content. husa masina caini Thanks so much for sharing this awesome info! I am looking forward to see more postsby you! husa masina caini Wow, cool post. I’d like to write like this too – taking time and real hard work to make a great article… but I put things off too much and never seem to get started. Thanks though. situs togel Thanks for your insight for your fantastic posting. I’m glad I have taken the time to see this. situs toto https://www.spartanhack.com/

  • I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. wedding venue in Denver I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. hptoto I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. olxtoto login I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. olxtoto login I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. it recruitment agency koitoto

  • Yes, I am entirely agreed with this article, and I just want say that this article is very helpful and enlightening. I also have some precious piece of concerned info !!!!!!Thanks. 도봉 급전 대출

  • This really which means delightful not to mention original. I just absolutely adore typically the styles not to mention anyone who will become it again in your mailing could be cheerful. 대부사이트

  • That i taken aback when using the exploration everyone intended to get this to selected present astounding. Terrific process! DOMINOS DROUIN

  • Discount put up, Regards for the purpose of showing This unique practical knowledge. Excellently crafted piece of writing, if perhaps virtually all web guru proposed an identical standard of articles and other content whenever you, the on-line world will be more effective destination. Why not keep writing! https://jrpromotions-western-cape.co.za/

  • With thanks for any posting plus superb recommendations.. sometimes I actually as well reckon that diligence is definitely a vey important ingredient of finding being successful. https://isilumko.co.za/

  • Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. fototapety 3d

  • Quite decent, stunning, fact-filled knowledge right. Any reports Don't sadden, and also most certainly holds true right additionally. You will frequently can result in a helpful look at. Will you indicate to We're content?: )#) Preserve the fantastic articles or reviews. biurko dla dziewczynki