Solved

csv to single dimmensional array

Posted on 2010-09-20
4
318 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now