GroupBy in List of items using LINQ

Question

I have a list that contains item like below:

Now I want to group according to language index (Languages[x]) like below:

Group-1:
model.Languages[0].Employer
model.Languages[0].Title

Group-2:
model.Languages[1].Employer
model.Languages[1].Title

Can AnyBody tell me how can I do this?

Please, do not post code as images. You can use `where` clause with index — Pavel Anikhouski, Jan 09 '20 at 11:12
@PavelAnikhouski Actually I wanted to show my generated list with code, that's why I pest the image. — Arif, Jan 09 '20 at 11:15

score 1 · Answer 1 · answered Jan 09 '20 at 11:20

1

If you believe your values will be consistent, you can try the below:

var groupedLanguages = languages.GroupBy(c => c.Substring(0, c.LastIndexOf('.')));

That will group by: "model.Languages[xx]"

answered Jan 09 '20 at 11:20

Oyyou

score 1 · Accepted Answer · answered Jan 09 '20 at 11:20

1

You can use Regex to extract the key:

var grouped = languages.GroupBy(l => Regex.Match(l, @"Languages\[\d+\]").Value);

answered Jan 09 '20 at 11:20

Johnathan Barclay

I definitely prefer your answer over mine. I really need to learn Regex! – Oyyou Jan 09 '20 at 11:22
@Oyyou yes, I put it off for a while, but couldn't cope without it now. – Johnathan Barclay Jan 09 '20 at 11:23
Good one! Maybe the expression should be `"model.Languages[@"model.Language\[\d+\]"`. – Felipe Oriani Jan 09 '20 at 11:24
@FelipeOriani that's an inavlid expression. Do you mean `@"model.Languages\[\d+\]"`? That would work as well, but the `model.` prefix is unnecessary, and the OP asked to group on the `Languages[x]` part. – Johnathan Barclay Jan 09 '20 at 11:29

2 Answers2