Skip first line in csv file

Question

1.00/5 (1 vote)

See more:

Hi,

Below is my CSV content

Number of managed system,
80, compliance
7, non_colpliance

I need only these values (80 and 7). I need to skip the rest of the data

Below is my code

C#

StreamReader sr = new StreamReader(filepath);
            string line = sr.ReadLine();
            string[] value = line.Split(',');
            DataTable dt = new DataTable();
            DataRow row;
            foreach (string dc in value)
            {
                dt.Columns.Add(new DataColumn(dc));
            }
            while ( !sr.EndOfStream )
            {
                value = sr.ReadLine().Split(',');
                if(value.Length == dt.Columns.Count)
                {
                    row = dt.NewRow();
                    row.ItemArray = value;
                    dt.Rows.Add(row);
                }
            }

Please help me to achive this.

Thanks in advance.

Posted 11-Sep-13 18:28pm

srmohanr

Add a Solution

Comments

Dholakiya Ankit 13-Sep-13 4:28am

you need values from column 80 nd 7 or whole column 80 and 7?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-09-11T18:54:00

Add another ReadLine in the very beginning; it will skip first line. When you use result of Split, use only the element of the resulting array at index 0. That's all.

Better yet, as your file is small, instead of using String.Reader, use System.IO.File.ReadAllLines. It will return you the array of lines, so you can ignore the line with the index 0. Please see:
http://msdn.microsoft.com/en-us/library/system.io.file.readalllines.aspx[^].

—SA

MuhammadUSman1 · Answer 2 · 2013-09-12T19:39:00

Solution 2

Check following link.

File.ReadAllLines Method with example

Posted 12-Sep-13 19:39pm

MuhammadUSman1

Maciej Los · Answer 3 · 2013-09-12T20:36:00

Solution 3

Why to read CSV file using Reader[^] if it possible to use OLEDB[^] to import data[^]?

Posted 12-Sep-13 20:36pm

Maciej Los