Convert array of strings to Dictionary<string, int> c# then output to Visual Studio

Question

I have an array of strings like so:

[0]Board1
[1]Messages Transmitted75877814
[2]ISR Count682900312
[3]Bus Errors0
[4]Data Errors0
[5]Receive Timeouts0
[6]TX Q Overflows0
[7]No Handler Failures0
[8]Driver Failures0
[9]Spurious ISRs0

just to clarify the numbers in the square brackets indicate the strings position in the array

I want to convert the array of strings to a dictionary with the string to the left of each number acting as the key, for example (ISR Count, 682900312)

I then want to output specific entries in the dictionary to a text box/table in visual studio (which ever is better) it would be preferable for the numbers to be left aligned.

excuse my naivety, I'm a newbie!

Which framework are you targeting?

Mark Bertenshaw
– Mark Bertenshaw

2012-09-11 11:30:39 +00:00
Commented Sep 11, 2012 at 11:30 — Mark Bertenshaw
– Mark Bertenshaw, Commented Sep 11, 2012 at 11:30

Nikhil Agrawal · Accepted Answer · 2012-09-11 11:41:18Z

4

Pretty Simple. Tried and Tested

string[] arr = new string[] { "Board1", "ISR Count682900312", ... };

var numAlpha = new Regex("(?<Alpha>[a-zA-Z ]*)(?<Numeric>[0-9]*)");

var res = arr.ToDictionary(x => numAlpha.Match(x).Groups["Alpha"], 
                           x => numAlpha.Match(x).Groups["Numeric"]);

enter image description here

edited Sep 11, 2012 at 11:41

answered Sep 11, 2012 at 11:36

Nikhil Agrawal

48.8k25 gold badges134 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jimmy Over a year ago

Thanks! But... 'System.Array' does not contain a definition for 'ToDictionary' am I missing an assembly reference?

Nikhil Agrawal Over a year ago

@JimBarton: Yes. Include System.Linq assembly

Lews Therin · Accepted Answer · 2012-09-11 11:32:27Z

1

string[] strings = { "Board1", "Messages232" };

        Dictionary<string, int> dictionary = new Dictionary<string, int>();

        foreach (var s in strings)
        {
            int index = 0;
            for (int i = 0; i < s.Length; i++)
            {
                if (Char.IsDigit(s[i]))
                {
                    index = i;
                    break;
                }
            }
            dictionary.Add(s.Substring(0, index), int.Parse(s.Substring(index)));
        }

edited Sep 11, 2012 at 11:32

answered Sep 11, 2012 at 11:27

Lews Therin

11k4 gold badges51 silver badges72 bronze badges

4 Comments

Brad Rem Over a year ago

You need to short circuit your loop after you find the first digit.

Jimmy Over a year ago

Thanks for the reply, I get 'Input string was not in a correct format.'

Mark Bertenshaw Over a year ago

+1 Of course, this is assuming that there is no number embedded in the middle of the "key".

Lews Therin Over a year ago

@MarkBertenshaw Good point. If so, the OP should clarify that. Nice catch :)

Zen · Accepted Answer · 2012-09-11 11:45:49Z

    var stringArray = new[]
                          {
                              "[0]Board1",
                              "[1]Messages Transmitted75877814",
                              "[2]ISR Count682900312",
                              "[3]Bus Errors0",
                              "[4]Data Errors0",
                              "[5]Receive Timeouts0",
                              "[6]TX Q Overflows0",
                              "[7]No Handler Failures0",
                              "[8]Driver Failures0",
                              "[9]Spurious ISRs0"
                          };


    var resultDict = stringArray.Select(s => s.Substring(3))
        .ToDictionary(s =>
                      {
                          int i = s.IndexOfAny("0123456789".ToCharArray());
                          return s.Substring(0, i);
                      },
                      s =>
                      {
                          int i = s.IndexOfAny("0123456789".ToCharArray());
                          return int.Parse(s.Substring(i));
                      });

EDIT: If the numbers in brackets are not included in the strings, remove .Select(s => s.Substring(3)).

Mike Perrenoud · Accepted Answer · 2012-09-11 11:35:47Z

0

Here you go:

string[] strA = new string[10]
{
    "Board1",
    "Messages Transmitted75877814",
    "ISR Count682900312",
    "Bus Errors0",
    "Data Errors0",
    "Receive Timeouts0",
    "TX Q Overflows0",
    "No Handler Failures0",
    "Driver Failures0",
    "Spurious ISRs0"
};
Dictionary<string, int> list = new Dictionary<string, int>();

foreach (var item in strA)
{
    // this Regex matches any digit one or more times so it picks
    // up all of the digits on the end of the string
    var match = Regex.Match(item, @"\d+");

    // this code will substring out the first part and parse the second as an int
    list.Add(item.Substring(0, match.Index), int.Parse(match.Value));
}

answered Sep 11, 2012 at 11:35

Mike Perrenoud

68.1k32 gold badges167 silver badges238 bronze badges

Collectives™ on Stack Overflow

Convert array of strings to Dictionary<string, int> c# then output to Visual Studio

4 Answers 4

2 Comments

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related