Any way to read a CSV into an array or datatable using linq?

Question

I have a long(ish) csv that I need to ingest into either a multi dimensional array or data table to be iterated over. The format is simple:

filepathX, sizeinbytes1 (i.e. C:\temp\yourfile.txt, 12345)

In straight .net I used the OleDb provider, however the Unity engine does not seem to play nice with this reference. I cannot use external libraries like FileHelpers.

Reading CSV is a tricky business. There is a reasonably popular parser available with downloadable source code distributed under MIT license, here is the link. — Sergey Kalinichenko
– Sergey Kalinichenko, Commented May 27, 2012 at 21:15
Out of curiosity when you say "didn't play nice" what issues did you see? It maybe easier to fix them than change the code base. — Jeremy Thompson
– Jeremy Thompson, Commented Dec 9, 2012 at 2:03

dsz · Accepted Answer · 2012-12-08 23:04:37Z

1

dasblinkenlight is right about CVS being (in general) non-trivial to parse, but you have described a VERY specific format.

Personlly, I'd just read the file line by line and use LastIndexOf(",") to split off the size - that at least will protect you from the possability that there's a comma in the file name.

Fianlly, do you really need it in an array or data table? You could wrap the file reading into your own iterator using "yield return" (return a custom struct or a Tuple if you're lazy!), and at least have "nice" code sitting on top doing the iteration.

edited Dec 8, 2012 at 23:04

answered May 27, 2012 at 23:18

dsz

5,3321 gold badge46 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Any way to read a CSV into an array or datatable using linq?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related