Get Column Index with Name Using StreamReader

Question

Get Column Index with Name Using StreamReader

Winston TheFifth 106

How do you get the column index with the column name with a StreamReader?

int column_index = . . .
string column_name;

using( StreamReader sr = new StreamReader( "MyFile.csv"))
{
string line = sr.ReadLine( );
var a = line.Split( ",")
var index = line.IndexOf("ColumnName");
}

Viorel 121.6K Reputation points

2022-07-15T06:18:00.043+00:00

Try something like this:

column_index = Array.IndexOf(a, column_name);

Accepted answer

2 additional answers

Your answer

Viorel 121.6K Reputation points

2022-07-15T06:18:00.043+00:00

Try something like this:

column_index = Array.IndexOf(a, column_name);

Answer 1

Jack J Jun 25,296

@Winston TheFifth , Welcome to Micosoft Q&A, you could try the following code to use List<T>.IndexOf Method to get the index based on the columnname.

    string column_name="Age";  
    using (StreamReader sr = new StreamReader(path))  
    {  
        string line = sr.ReadLine();  
        var a = line.Split(',');  
        int index=a.ToList().IndexOf(column_name);  
        Console.WriteLine("index is "+index);  

    }

Csv and tested result:

Hope this could help you.

Best Regards,
Jack

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Winston TheFifth 106 Reputation points

2022-07-15T10:59:00.517+00:00

I misunderstood what IndexOf is. What I need is the column ordinal ie the 0 for the first column, 1 for the second column, etc. How do you do that? Thank you.
Jack J Jun 25,296 Reputation points

2022-07-15T17:50:20.677+00:00

@Winston TheFifth , thanks for the feedback, I am not full understand your meaning. In my situation, Age is the second column and the index is 1. Do you have question about it?
Winston TheFifth 106 Reputation points

2022-07-16T01:54:08.3+00:00

I'm sorry. You're right. I was looking at the ID in your screenshot. Thank you!

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

1 deleted comment

Comments have been turned off. Learn more

Answer 3

internal class Auto

{

public string Gyarto;

public string Tipus;

public string Szin;

public int Ar;

// 1. Feladat

public Auto(string gyarto, string tipus, string szin, string ar)

{

this.Gyarto = gyarto;

this.Tipus = tipus;

this.Szin = szin;

this.Ar = int.Parse(ar);

}

internal class Program

{

static void Main(string[] args)

{

#region 1. Feladat

// a) alfeladat fentebb

#region b) alfeladat

StreamReader sr = null;

List<Auto> autok = new List<Auto>();

#region c) alfeladat

try

{

sr = new StreamReader("autok.csv");

sr.ReadLine(); //Fejléc sor

while (!sr.EndOfStream)

{

string[] sor = sr.ReadLine().Split(';');

autok.Add(new Auto(sor[0], sor[1], sor[2], sor[3]));

}

finally

{

if (sr == null)

{

Console.WriteLine("A fájlbeolvasás nem sikerült.");

}

else

{

sr.Close();

}

#endregion

#region 2. Feladat

Console.WriteLine($"\n2. Feladat \nA lista {autok.Count} elemet tartalmaz.");

Share via

Get Column Index with Name Using StreamReader

2 additional answers

Your answer