Splitting a string into a List of string array in C#

Question

I am trying to convert the following string:

"CN=Test,OU=ABC,OU=Company,DC=CFLA,DC=domain"

into this form (a list of string arrays):

[
  {"CN" , "Test"},
  {"OU" , "ABC"},
  {"OU" , "Company"},
  {"DC" , "CFLA"},
  {"DC" , "domain"},
]

What I have tried already is converting the string into a list of dictionaries. I tried splitting the string twice. First on the basis of , and then on the basis of =.

Following is the code I used:

var result = str.Split(',')
                .Select(line => line.Split('='))
                .ToDictionary(b=> b[0], b=> b[1])
                .ToList();

But it gives me the following exception: 'System.ArgumentException: 'An item with the same key has already been added', rightly so as 'OU' and 'DC' are being repeated as keys.

What I want now is to split/convert/process this string into a List of string arrays (as shown above). Is it possible?

Or kindly guide me with an alternate solution. Thanks in advance.

P.S. I have hundreds of these strings and I only want the value of the first "OU" from every string.

Just remove your ToDictionary call, and you'll already have a list of string arrays. Although if the goal is just "to get the first OU from each string" then there are simpler approaches. — Jon Skeet
– Jon Skeet, Commented Oct 15, 2019 at 11:12

blackforest-tom · Accepted Answer · 2019-10-15 11:22:42Z

8

If you really want a List of string-Arrays, just omit the "ToDictionary" line.

var result = str.Split(',')
            .Select(line => line.Split('='))
            .ToList();

will give you a List of Arrays, with each Array [0] holding the "Key", and [1] holding the "Value"

ad PS: To get the first "OU" value, you can use a regular expression:

var firstOuRegex = new Regex("[oO][uU]=([^,]+)", RegexOptions.Compiled);
var testString = "CN=Test,OU=ABC,OU=Company,DC=CFLA,DC=domain";

var result = firstOuRegex.Match(testString).Groups[1];

edited Oct 15, 2019 at 11:22

answered Oct 15, 2019 at 11:14

blackforest-tom

4854 silver badges8 bronze badges

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

1 Comment

ShaneDemskie Over a year ago

Probably better to just use regex for the entire solution if you're going to use it at all.

Kirill Gandyl · Accepted Answer · 2019-10-15 11:23:20Z

2

You have two "OU" entries in your expression. As a result, you cannot translate it to a dictionary. Instead, translate it to a list of KeyValuePair

var result = str.Split(',')
            .Select(line => line.Split('='))
            .Select(tuple => new KeyValuePair<string, string>(tuple[0], tuple[1]))
            .ToList();

answered Oct 15, 2019 at 11:23

Kirill Gandyl

363 bronze badges

Comments

Sharunas Bielskis · Accepted Answer · 2019-10-15 11:41:28Z

I suppose the code below will provide you with the required result:

class Program
{
    static void Main(string[] args)
    {
        string initialString = "CN=Test,OU=ABC,OU=Company,DC=CFLA,DC=domain";

        List<string[]> finalList = new List<string[]>();
        string [] firstSplitStringsArray = initialString.Split(',');
        foreach (var item in firstSplitStringsArray)
        {
            string [] secondlySplittedStringsArray = item.Split('=');
            finalList.Add(secondlySplittedStringsArray);
        }
    }
}

If you need only the first OU value, the code can be:

        string initialString = "CN=Test,OU=ABC,OU=Company,DC=CFLA,DC=domain";
        string requiredValue = string.Empty;

        string [] firstSplitStringsArray = initialString.Split(',');
        foreach (var item in firstSplitStringsArray)
        {
            string [] secondlySplittedStringsArray = item.Split('=');
            if (secondlySplittedStringsArray[0] == "OU")
            {
                requiredValue = secondlySplittedStringsArray[1];
                break;
            }
        }

Collectives™ on Stack Overflow

Splitting a string into a List of string array in C#

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related