CODEWITHSUNDEEP
c#
user1202434
user1202434

Reputation: 2273

String parsing C# creating segments?

I have a string in the form of:

"company=ABCorp, location=New York, revenue=10million, type=informationTechnology"

I want to be able to parse this string out and get "name", "value" pairs in the form of

company = ABCCorp

location= New York etc.

This could be any suitable data structure to store. I was thinking maybe a Dictionary<string, string>() but im open to suggestions.

Is there a suitable way of doing this in C#?

EDIT: My final goal here is to have something like this:

Array[company] = ABCCorp. Array[location] = New York.

What data structure could we use to achieve the above? MY first thought is a Dictionary but I am not sure if Im missing anything.

thanks

Upvotes: 2

Views: 437

Answers (4)

Reed Copsey
Reed Copsey

Reputation: 564451

Using String.Split and ToDictionary, you could do:

var original = "company=ABCorp, location=New York, revenue=10million, type=informationTechnology";

var split = original.Split(',').Select(s => s.Trim().Split('='));

Dictionary<string,string> results = split.ToDictionary(s => s[0], s => s[1]);

Upvotes: 4

Brian
Brian

Reputation: 2229

string s = "company=ABCorp, location=New York, revenue=10million, type=informationTechnology";
var pairs = s.Split(',')
        .Select(x => x.Split('='))
        .ToDictionary(x => x[0], x => x[1]);

pairs is Dictionary with the key value pair. The only caveat is you will probably want to deal with any white space between the comma and the string.

Upvotes: 3

Matt Razza
Matt Razza

Reputation: 3654

I'm assuming a weak RegEx/LINQ background so here's a way to do it without anything "special".

string text = "company=ABCorp, location=New York, revenue=10million, type=informationTechnology";

string[] pairs = text.Split(',');
Dictionary<string, string> dictData = new Dictionary<string, string>();

foreach (string currPair in pairs)
{
    string[] data = currPair.Trim().Split('=');

    dictData.Add(data[0], data[1]);
}

This has the requirement that a comma (,) and an equal-sign (=) never exist in the data other than as delimiters.

This relies heavily on String.Split.

Upvotes: 1

Simon Ejsing
Simon Ejsing

Reputation: 1495

It depends a lot on the expected syntax. One way to do this is to use String.Split: http://msdn.microsoft.com/en-us/library/system.string.split(v=vs.110).aspx

First split on comma, then iterate over all items in the string list returned and split those on equality.

However, this requires that comma and equality are never present in the values?

Upvotes: 2

Related Questions