Extracting digits with Regex

Question

I have this string : [{"Weight":70,"CustomerId":45},{"Weight":30,"CustomerId":733‌}] please note that quotation marks are parts of this string I need to extract the digits for 'weight' and 'customerId' separately. I tried to do it like this for weight :

MatchCollection Weightmatches = Regex.Matches(r["Formula"].ToString(), @"""Weight"":(\d+),");

(there might be more Weight or Customer numbers on this string)

but I can't seem to understand how to isolate the numbers alone.

please help!!

You should not use a regex to parse JSON, in C#, use JSON.NET to do that. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Apr 25, 2017 at 7:50
Sorry, I still do not understand: do you want to get a list of KeyValuePairs with Wieght as keys and CustomerId as values? var results = new List<KeyValuePair<int, int>>();? — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Apr 25, 2017 at 9:16
yes, I thought about tuple<int,int> at first . but this is a better option — Jonathan
– Jonathan, Commented Apr 25, 2017 at 9:18

Wiktor Stribiżew · Accepted Answer · 2017-04-25 09:23:05Z

1

To properly parse JSON, it is recommended to use a JSON parser. JSON.NET provides one, just install it as a NuGet package and use the following code:

var json_data = "[{\"Weight\":70,\"CustomerId\":45},{\"Weight\":30,\"CustomerId\":733}]";
dynamic parsedObject = Newtonsoft.Json.JsonConvert.DeserializeObject(json_data);
var results = new List<KeyValuePair<int, int>>();
foreach (dynamic entry in parsedObject)
{
    if (entry.Weight != null && entry.CustomerId != null)
        results.Add(new KeyValuePair<int, int>(int.Parse(entry.Weight.ToString()), int.Parse(entry.CustomerId.ToString())));
}

The output:

answered Apr 25, 2017 at 9:23

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

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

Comments

l33t · Accepted Answer · 2017-04-25 08:02:29Z

0

Using a JSON parser is the right answer here. But I suppose you could do a Regex search similar to this:

(?:["][^"]+["] : (\d+))

Or if you want to capture the text as well:

(?:["]([^"]+)["] : (\d+))

answered Apr 25, 2017 at 8:02

l33t

20.3k20 gold badges116 silver badges192 bronze badges

5 Comments

Jonathan Over a year ago

can you please write the full line? something is not clear to me with the syntax

Wiktor Stribiżew Over a year ago

@Jonathan: Do not use regex, please. Do you want me to post a JSON.NET based solution? It is not really that difficult, and is much more readable.

Wiktor Stribiżew Over a year ago

@Jonathan: Then please share the full JSON data in the question as your current string is not a valid JSON.

Jonathan Over a year ago

[{"Weight":70,"CustomerId":45},{"Weight":30,"CustomerId":733}]

Wiktor Stribiżew Over a year ago

Please add it to the question and specify what output you need.

Collectives™ on Stack Overflow

Extracting digits with Regex

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related