Add numbers part of a string using LINQ

Question

Can I add the numbers I get in a string format using the below code:

Size = a.Type == "Machines" ?string.Join(",", a.Info.DiskInfo.Select(b => b.Size)) : null,

The output of this code is: "50.00 GiB, 16.00 GiB", for example.

I decided to first remove the units from it so that I can add the numbers straight away. Therefore, I changed the code to:

Size = a.Type == "Machines" ? string.Join(",", a.Info.DiskInfo.Select(b => b.Size).Select(c => Regex.Replace(c, "[^0-9.]", ""))) : null,

Now, the output is: "50.00, 16.00"

How do I add these numbers which are in a string using LINQ, to get "66.00" as the output?

Since it is a string, you could try .Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(n => Convert.ToSingle(n.Trim())).Sum(); You could probably re-work that to avoid the string.Join at the beginning. — Ron Beyer
– Ron Beyer, Commented Apr 12, 2018 at 4:20
Hey @RonBeyer.. it is IEnumerable<string>.. I tried to do the below but I do not get nay output on Postman... ToString().Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Select(n => Convert.ToSingle(n.Trim())).Sum() — HJain
– HJain, Commented Apr 12, 2018 at 4:24
Then use .First() at the beginning of that, ie: .First().Split(...)... Don't use .ToString before it. — Ron Beyer
– Ron Beyer, Commented Apr 12, 2018 at 4:25

benPearce · Accepted Answer · 2018-04-12 04:58:24Z

2

Change the statement to:

Size = a.Type == "Machines" 
  ? a.Info.DiskInfo
     .Select(b => b.Size)
     .Select(c => Regex.Replace(c, "[^0-9.]", "")))
     .Where(x => !string.IsNullOrWhiteSpace(x))
     .Select(x => Convert.ToDecimal(x.Trim()))
     .Sum()
  : null,

For clarity on the LINQ pipeline:

Size = a.Type == "Machines"  
  ? a.Info.DiskInfo // object
     .Select(b => b.Size) // IEnumerable<string>
     .Select(c => Regex.Replace(c, "[^0-9.]", ""))) // IEnumerable<string>
     .Where(x => !string.IsNullOrWhiteSpace(x)) // IEnumerable<string>
     .Select(x => Convert.ToDecimal(x.Trim())) // IEnumerable<decimal>
     .Sum() // single decimal
     .ToString() // single string
  : null,

edited Apr 12, 2018 at 4:58

answered Apr 12, 2018 at 4:22

benPearce

38.5k14 gold badges68 silver badges96 bronze badges

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

3 Comments

Ron Beyer Over a year ago

I'd upvote this if you put the entire thing in there, and got rid of the string.Join at the beginning.

HJain Over a year ago

@RonBeyer.. I am using string.join because Size being used in the select statement is a IEnumerable<string>: Select(b => b.Size).. So, not using string.Join() gives me an error.

benPearce Over a year ago

The LINQ statements form a pipeline, so what started as IEnumerable<string> gets converted to IEnumberable<decimal> by the last Select the a single decimal by the Sum. You could convert it back to a string by adding ToString() after the Sum

Collectives™ on Stack Overflow

Add numbers part of a string using LINQ

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related