KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Objective Sort a string that is displaying currency data like this $1,995.94 numerically in a set of data. Code I'm currently using the below code sample to convert the string value to decimal so that I can sort it properly. if (sortBy == "checkAmount") { StringBuilder sb = new StringBuilder(); foreach (var c in Convert.ToString(p.GetType().GetProperty(sortBy).GetValue(p, null))) { if (!char.IsDigit(c) && c != '.') { continue; } sb.Append(c); } return Convert.ToDecimal(sb.ToString()); } else { return p.GetType().GetProperty(sortBy).GetValue(p, null); } Problem What's a better way of doing this? It works, and that's cool, but it's not very elegant. Final Solution The answer provided by Servy works as expected , and I used that implementation for a while, but a colleague and I found an even better way so I'm documenting it here. BTW, I ended up using this solution in the end. decimal.Parse(input, NumberStyles.AllowCurrencySymbol | NumberStyles.Number);
Tags (comma-separated)
Save Edits
Cancel