Solved

csv to single dimmensional array

Posted on 2010-09-20
4
323 Views
Last Modified: 2013-11-07
Hi

I want to convert CSV file to a single dimmensional array in C#. How can I do that?

Regards
Karan Gupta
0
Comment
Question by:KaranGupta
  • 2
4 Comments
 
LVL 53

Accepted Solution

by:
Dhaest earned 333 total points
ID: 33715280
What exactly do you want ? For each line in the csv, 1 item in an array ?

Or in each row of the array, a list of string like example below ?
Building a Simple CSV Parser in C#
http://www.switchonthecode.com/tutorials/building-a-simple-csv-parser-in-csharp
0
 
LVL 22

Assisted Solution

by:Om Prakash
Om Prakash earned 167 total points
ID: 33715281
0
 
LVL 53

Assisted Solution

by:Dhaest
Dhaest earned 333 total points
ID: 33715321
A small quick example
using System;
using System.IO;

class Test 
{
    public static void Main() 
    {
        List<string> myFileInArray = new List<string>();
        try 
        {
            // Create an instance of StreamReader to read from a file.
            // The using statement also closes the StreamReader.

            using (StreamReader sr = new StreamReader("TestFile.txt")) 
            {
                string line;
                // Read and display lines from the file until the end of 
                // the file is reached.

                while ((line = sr.ReadLine()) != null) 
                {
                    myFileInArray(line);
                    Console.WriteLine(line);
                }
            }
        }
        catch (Exception e) 
        {
            // Let the user know what went wrong.
            Console.WriteLine("The file could not be read:");
            Console.WriteLine(e.Message);
        }
    }

Open in new window

0
 

Author Closing Comment

by:KaranGupta
ID: 33751113
Issue Fixed.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question