Looping StringBuilder strings

Hi,
    I have a C# StringBuilder with the below strings:

2.1.1 ICSS
2.1.1 ICSS
2.1.1 ICSS
2.1.4 User Interface
2.1.4 User Interface  
2.1.5 Alarm Management  
2.1.5 Alarm Management  
2.1.5 Alarm Management  
2.1.5 Alarm Management

How can I loop through these strings & count the total of each type. e.g. The results would be:
2.1.1. ICSS = 3
2.1.4 User Interface = 2
2.1.5 Alarm management = 4

Thanks
Paul.
LVL 1
pr_wainwrightAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike TomlinsonMiddle School Assistant TeacherCommented:
How are they delimited?

Regardless, use a HashTable type structure and add a counter variable to it using the strings as the key.  If the key already exists then increment the value already stored there.

What version C# are you using?
0
pr_wainwrightAuthor Commented:
Idle_Mind,
                I am using Visual Web Developer 2005. I have never used hash tables before. Any help on these appreciated.

Thanks
Paul.
0
Mike TomlinsonMiddle School Assistant TeacherCommented:
How are the strings delimited in the StringBuilder?....are they separated by comma, tab, something else?....
0
Mike TomlinsonMiddle School Assistant TeacherCommented:
I don't do web development...but hopefully this should give a good idea of how it can be done:
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private StringBuilder sb = new StringBuilder();
 
        private void Form1_Load(object sender, EventArgs e)
        {
            sb.Append("2.1.1 ICSS" + ",");
            sb.Append("2.1.1 ICSS" + ",");
            sb.Append("2.1.1 ICSS" + ",");
            sb.Append("2.1.4 User Interface" + ",");
            sb.Append("2.1.4 User Interface" + ",");
            sb.Append("2.1.5 Alarm Management" + ",");
            sb.Append("2.1.5 Alarm Management" + ",");
            sb.Append("2.1.5 Alarm Management" + ",");
            sb.Append("2.1.5 Alarm Management");
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            Dictionary<string, int> counts = new Dictionary<string, int>();
            foreach (String value in sb.ToString().Split(",".ToCharArray()))
            {
                if (!counts.ContainsKey(value))
                {
                    counts.Add(value, 1);
                }
                else
                {
                    counts[value] = counts[value] + 1;
                }
            }
 
            foreach (String key in counts.Keys)
            {
                MessageBox.Show(key + " = " + counts[key].ToString());
            }
        }
 
    }

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pr_wainwrightAuthor Commented:
Exactly what I needed. Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.