How to split a Guid List in to small part of lists

Question

I have a Guid List type of varchar(Max). This list has lots of Guid's which cross the sql limit.SO i have break this list in to small list as shown below.

 var sublists = customerList
               .Select((x, i) => new { Index = i, Value = x })
               .GroupBy(x => x.Index / 2000)
               .Select(x => x.Select(v => v.Value.ToString()).ToList())
               .ToArray();

But this list is coming in char format as shown below.

enter image description here

I am not getting why this is coming in char format. Am I making any mistakes?

Because Select Method take each character from customerList string. — Najera, May 05 '14 at 18:00

Sergio · Answer 1 · 2014-05-05T17:39:09.927

1

Try this:

string[] sublists = customerList.Substring(0,2000).Split(',');
sublists = sublists.Take(sublists.Length - 1).ToArray();

That should give you the results you are looking for.

edited May 05 '14 at 17:39

answered May 05 '14 at 14:31

Sergio

8,125
10
46
77

After doing this no changes in list – Amit Kumar May 05 '14 at 14:37
replace ToArray with ToList. if v.Value is a string, that should give you an object of type List – Sergio May 05 '14 at 14:40
What type is "Value"? – Sergio May 05 '14 at 14:46
CustomerList is a Guid List which is coming like '''Guid'',''Guid'',''Guid''' – Amit Kumar May 05 '14 at 14:47
Ex : customerList = @"'''70dd45f5-ac3f-4352-b8bd-cb5faad326bf'',''f5fc4992-fd77-498e-aa21-e1e963fc4e1f'',''be73ffdd-9c2a-42ae-b5e0-350945477eba'''; – Amit Kumar May 05 '14 at 14:49
changed my answer for this data form – Sergio May 05 '14 at 14:59
On split the compile time error is occurring.Split is not coming in intellisense. – Amit Kumar May 05 '14 at 15:06
Can you explain to me what you are trying to acomplish with this? .GroupBy(x => x.Index / 2000) – Sergio May 05 '14 at 16:32
This is used for splitting full list with 2000 records of sublist. – Amit Kumar May 05 '14 at 16:38
If there is other solution for splitting a Guid list in to sublists then please tell me .I am stuck in this problem. – Amit Kumar May 05 '14 at 16:40

score 1 · Accepted Answer · edited May 23 '17 at 12:28

1

If customerList is a big string:

var sublists = customerList
    .Split(",")
    .Select((x, i) => new { Index = i, Value = x })
    .GroupBy(x => x.Index / 2000)
    .Select(x => x.Select(v => v.Value).ToList())
    .ToList();

Is the same solution as here but you must add Split Method first.

edited May 23 '17 at 12:28

Community

1
1

answered May 05 '14 at 16:52

Najera

2,869
3
28
52

This is spltting smae way but sublist is not showing right output.If I have 3400 records in CustomerList then sublist should have index with (2000 and 1400 records). – Amit Kumar May 05 '14 at 17:13
If Customer List has 3400 list of Guid's.then It should be splits in 2 parts with index 0 and index 1.and index 0 should contain 2000 guids and index 1 should contain rest of guids. – Amit Kumar May 05 '14 at 17:28
Thanks. It was my mistake .Your previous solution was also right.And my problem is solved now. – Amit Kumar May 05 '14 at 18:05

How to split a Guid List in to small part of lists

2 Answers2