How to return an access a split string while using LINQ?

Question

I have a text file which is being read using File.ReadLines(filepath). It's filled with first and last names delimited using a :. Is there a way using LINQ in which I would be able to access the first and last name in the foreach loop for the returned datatype?

// john:doe
// david:smith
// michael:rogers

var Names = File.ReadLines(filepath)
    .Select(line => line.Split(':'));

foreach (var list in Names) 
listbox1.Items.Add(list); //(first name) before : 
listbox2.Items.Add(list); //(last name) after :

Is it mullti column ListBox ?

Hari Prasad
– Hari Prasad

2016-08-26 02:22:36 +00:00
Commented Aug 26, 2016 at 2:22 — Hari Prasad
– Hari Prasad, Commented Aug 26, 2016 at 2:22

Kinetic · Accepted Answer · 2016-08-26 00:53:51Z

2

Well, you're almost there. All you're missing is to get the firstName from the first item in the array and the last name in the second item.

foreach (var list in Names) 
{
    listbox1.Items.Add(list[0]); //(first name) before : 
    listbox2.Items.Add(list[1]); //(last name) after :
}

answered Aug 26, 2016 at 0:53

Kinetic

2,66019 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Slai · Accepted Answer · 2016-08-26 00:52:14Z

0

list[0] is the first and list[1] the second

listbox1.DataSource = Names.Select(a => a[0]).ToArray();
listbox2.DataSource = Names.Select(a => a[1]).ToArray();

answered Aug 26, 2016 at 0:52

Slai

23k5 gold badges49 silver badges55 bronze badges

Comments

Hari Prasad · Accepted Answer · 2016-08-26 02:29:15Z

0

Based on your example, I assume it is not multicolumn ListBox.

Use SelectMany to flatten the hierarchy after splits.

listbox1.DataSource = File.ReadLines(filepath)
                          .SelectMany(line=>line.Split(':'));

Or, use AddRange method and do this

 ListBox1.Items.AddRange(File.ReadLines(filepath)
                             .SelectMany(line=>line.Split(':')
                             .Cast<object>()  // I think this is redundant remove if not required.
                             .ToArray()
                        );

answered Aug 26, 2016 at 2:29

Hari Prasad

17k4 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to return an access a split string while using LINQ?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related