How to arrange or grouping value in the list? in C#

Pavi S

14y2.1k.NET

i have sorted list like this(please refer below code)

code
======

var sd = new SortedList<string, string>();
for (int p = 0; p < yearMatch.Count; p++)

{
sd.Add(YearAdded[p], Id[p]);
}
yearcount = sd.Keys.ToArray();
Id = sd.Values.ToArray();
=========================================
Example
===========
yearcount having year value 2000a,2000b,2000c,20003
Id having value 0020,0025,0030,0035
i want the output like this year value 2000a,b,c,2003
Id value 0020,0025,0030,0035
======================
if same year in the list i want to group that like above i said, i tried in many ways. please any one help guys.its imp and urgent.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
This adjusted version should deal with that:

using System;
using System.Collections.Generic;
using System.Linq;

class Program
{
static void Main()
{
string[] yearcount = {"2003a", "2005b", "2002b", "2001"};
string[] Id = {"bb0025", "bb0030", "bb0020", "bb0015"};

var sd = new SortedList();

for(int i = 0; i < yearcount.Length; i++)
{
sd.Add(yearcount[i], Id[i]);
}

yearcount = sd.Keys.ToArray();

var years = new List();

for(int i = 0; i < yearcount.Length; i++)
{
string temp = yearcount[i].Substring(0, 4);
int len = yearcount[i].Length;

if(!years.Contains(temp))
{
years.Add(temp);
}
else if (len == 5)
{
yearcount[i] = yearcount[i].Substring(len - 1);
}
}

Id = sd.Values.ToArray();

for(int i = 0; i < yearcount.Length; i++)
{
Console.Write("{0}" , yearcount[i]); // 2001, 2002b, 2003a, 2005b
if (i < yearcount.Length - 1) Console.Write(",");
}

Console.WriteLine();

for(int i = 0; i < Id.Length; i++)
{
Console.Write("{0}" , Id[i]); // bb0015, bb0020, bb0025, bb0030
if (i < Id.Length - 1) Console.Write(",");
}

Console.ReadKey();
}
}
Vulpes14y ago
It's very difficult to do replacements like this in a general way using normal regular expressions.

However, if you use a MatchEvaluator delegate, like I did in your other thread (http://www.c-sharpcorner.com/Forums/Thread/159829/regular-expression-in-C-Sharp.aspx ), then it's much easier:

using System;
using System.Text.RegularExpressions;

class Program
{
static int lastYear;

static void Main()
{
string yearval = "2001,2002a,2002b,2005b";
yearval = Regex.Replace(yearval, @"\d{4}[a-z]?", Evaluator);
Console.WriteLine(yearval);
Console.ReadKey();
}

static string Evaluator(Match m)
{
int year;
if(!int.TryParse(m.Value.Substring(0, 4), out year)) return m.Value;
int len = m.Value.Length;

if (year == lastYear)
{
if (len == 5) return m.Value.Substring(len - 1);
}
else
{
lastYear = year;
}

return m.Value;
}
}
Pavi S14y ago
Some changes in this logic, i want to use regular expression for grouping year
using System;
using System.Collections.Generic;
using System.Linq;

class Program
{
    static void Main()
    {
       string[] yearcount = {"2002a", "2005b", "2002b", "2001"};
       string[] Id = {"bb0025", "bb0030", "bb0020", "bb0015"};

       var sd = new SortedList();

       for(int i = 0; i < yearcount.Length; i++)
       {
          sd.Add(yearcount[i], Id[i]);
       }

       yearcount = sd.Keys.ToArray();
       Id = sd.Values.ToArray();

       yearval = Regex.Replace(yearval, @"\b(\d{4})([a-z]),\1([a-z])\b", @"\1\2,\3"); //using like this i want the output like 2001,2002a,b,2005b

       Console.ReadKey();
    }
}
======================================
i tried the above code it didnt work please help as soon as possible.
Pavi S14y ago
its Awesome , good job, thanks lot.
Pavi S14y ago
really thanks, great.

if u give below input it wont work

string[] yearcount = { "2003a", "2005b", "2002b", "2001" };
string[] Id = { "bb0025","bb0030","bb0020","bb0015" };

it will give output like this ly 2001,b,2003a,b
bb0015,bb0020,bb0025,bb0030

but i want the output like this 2001,2002b,2003a,2005b

the logic is if year same that time ly should group the two years
example
=========
2002b,2002a ---->in this condition ly will group like this 2002a,b
2003a,2002b ---->in this condition the year is diffrent so just sort year enough like 2002b,2003a

please help for me for this situation.
Vulpes14y ago
This should do it:

using System;
using System.Collections.Generic;
using System.Linq;

class Program
{
static void Main()
{
string[] yearcount = {"2000c", "2000a", "2003", "2000b"};
string[] Id = {"0030", "0020", "0035", "0025"};

var sd = new SortedList();

for(int i = 0; i < yearcount.Length; i++)
{
sd.Add(yearcount[i], Id[i]);
}

yearcount = sd.Keys.ToArray();

for(int i = 0; i < yearcount.Length; i++)
{
char last = yearcount[i].Last();
if (!Char.IsDigit(last) && last != 'a') yearcount[i] = last.ToString();
}

Id = sd.Values.ToArray();

for(int i = 0; i < yearcount.Length; i++)
{
Console.Write("{0}" , yearcount[i]); // 2000a, b, c, 2003
if (i < yearcount.Length - 1) Console.Write(",");
}

Console.WriteLine();

for(int i = 0; i < Id.Length; i++)
{
Console.Write("{0}" , Id[i]); // 0020, 0025, 0030, 0035
if (i < Id.Length - 1) Console.Write(",");
}

Console.ReadKey();
}
}