LINQ version equivalent

[Member 7278598]

I am trying to get my head around LINQ and am going through some old code to practice, below is some code that i want to convert but cannot work out how to do it.
anyone have any ideas please.
Reading a csv file, getting first element only with some blank lines and should be able to populate combobox with something like:
cboSiteLocation.Items.AddRange(lines.ToArray());

using (StreamReader sr = new StreamReader(filepath))
{
IEnumerable<string> lines = File.ReadLines(filepath); // LINQ query here

                string\[\] element;

                foreach (string line in lines)
                {
                    if (!string.IsNullOrEmpty(line))
                    {
                        element = line.Split(',');
                        this.cboSiteLocation.Items.Add(element\[0\].Trim());
                    }
                }                    
            }

Thanks in advance

[Pete OHanlon]

Are you looking for something like this perhaps?

IEnumerable<string> output = File.ReadAllLines(@"C:\Course\socket.io\example1Copy\views\index.jade")
.Where(x => !string.IsNullOrWhiteSpace(x))
.Select(x => x.Split(new char[]{' '}, StringSplitOptions.RemoveEmptyEntries).FirstOrDefault());

[Member 7278598]

Yes thank you, exactly what i wanted. ;)

[Pete OHanlon]

You are welcome. Glad to help.