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

Question

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.

Vulpes · 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 { sd.Add(yearcount[i] Id[i]); } yearcount = sd.Keys.ToArray(); var years = new List (); for(int i = 0; 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 { Console.Write({0}  yearcount[i]); // 2001 2002b 2003a 2005b if (i } Console.WriteLine(); for(int i = 0; i { Console.Write({0}  Id[i]); // bb0015 bb0020 bb0025 bb0030 if (i } Console.ReadKey(); } }

Vulpes · Answer

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 = 20012002a2002b2005b; 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 S · Answer

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 { 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 20012002ab2005b Console.ReadKey(); } } ====================================== i tried the above code it didnt work please help as soon as possible.

Pavi S · Answer

its Awesome  good job thanks lot.

Pavi S · Answer

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 2001b2003ab bb0015bb0020bb0025bb0030 but i want the output like this 20012002b2003a2005b the logic is if year same that time ly should group the two years example ========= 2002b2002a ---->in this condition ly will group like this 2002ab 2003a2002b ---->in this condition the year is diffrent so just sort year enough like 2002b2003a please help for me for this situation.

Vulpes · Answer

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 { sd.Add(yearcount[i] Id[i]); } yearcount = sd.Keys.ToArray(); for(int i = 0; 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 { Console.Write({0}  yearcount[i]); // 2000a b c 2003 if (i } Console.WriteLine(); for(int i = 0; i { Console.Write({0}  Id[i]); // 0020 0025 0030 0035 if (i } Console.ReadKey(); } }