Extract all numbers in string to array

Question

I have a string like this

+3.15% price per day(+63.00% price at day 20)

and I want to be able to export it into an array so it becomes something like this

{3.15 , 63.00, 20}

Can someone help me with this? I'm really stuck at this right now, as I'm not 100% sure how to approach it :\ The reason why I want to do this is because I want to multiple the numbers inside that string by a number like 4, so the result will become

+12.60% price per day(+252.00% price at day 20)

Here are all the possible cases

-3.15% price per day(-63.00% price at day 20)

=>  -12.60% price per day(-252.00% price at day 20)

+0.76 price per day(+15.20 price at day 20)

=>  +3.04 price per day(+60.80 price at day 20)

What have you tried so far? Have you looked at methods such as Int.TryParse and Double.TryParse? If not, then do! — Wai Ha Lee
– Wai Ha Lee, Commented May 8, 2015 at 6:05
this question has nothing to do with "Extract all numbers in string to array" — fubo
– fubo, Commented May 8, 2015 at 6:37

General-Doomer · Accepted Answer · 2015-05-08 06:50:32Z

2

// export numbers
string input = "+3% price per day(+60% price at day 20)";
int[] array = Regex.Matches(input, @"\d+").OfType<Match>().Select(e => int.Parse(e.Value)).ToArray();

// replace numbers
double k = 3;
string replaced = Regex.Replace(input, @"\d+", e => (int.Parse(e.Value) * k).ToString());

// replace only percents
k = 4;
string replacedPercents = Regex.Replace(input, @"(\d+)%", e => (int.Parse(e.Groups[1].Value) * k).ToString() + "%");

// floating conversion
input = "+0.87 price per day(+63.00 price at day 20)";
string replacedFloating = Regex.Replace(input, @"\+(\d+\.(\d+)|\d+)", e => "+" + (double.Parse(e.Groups[1].Value, CultureInfo.InvariantCulture) * k).ToString(e.Groups[2].Length == 0 ? "0" : "0." + new string('0', e.Groups[2].Length), CultureInfo.InvariantCulture));

// floating conversion with negatives
input = "-0.87 price per day(+63.00 price at day 20)";
string replacedFloatingNegative = Regex.Replace(input, @"([+-])(\d+\.(\d+)|\d+)", e => e.Groups[1].Value + (double.Parse(e.Groups[2].Value, CultureInfo.InvariantCulture) * k).ToString(e.Groups[3].Length == 0 ? "0" : "0." + new string('0', e.Groups[3].Length), CultureInfo.InvariantCulture));

replaced is

+9% price per day(+180% price at day 60)

replacedPercents is

+12% price per day(+240% price at day 20)

replacedFloating is

+12.60 price per day(+252.00 price at day 20)

replacedFloatingNegative is

-3.48 price per day(+252.00 price at day 20)

edited May 8, 2015 at 6:50

answered May 8, 2015 at 5:55

General-Doomer

2,76115 silver badges13 bronze badges

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

12 Comments

User13888 Over a year ago

Thank you so much. That's almost perfect. the problem with this is that the numbers sometimes have decimals, and somehow that messes up the final numbers. For example, if it's 0.87, after you multiply it by 4 it should be 3.48, so "+3.48 price per day(+69.60 price at day 20)". Do you think you can help me with this last part? Right now what it returns is 0.348 for some reason :\

General-Doomer Over a year ago

for "+0.87 price per day(+63.00 price at day 20)" result is "+3.48 price per day(+252.00 price at day 20)" (in last version of my code)

User13888 Over a year ago

Thank you, what if I need to do replacedPercentsFloating? the replacedFloating is working 100% now. The percent floating will most likely have -XX.XX% instead of +XX.XX%

User13888 Over a year ago

Thank you so much!!! The last thing is that when I try to run it, it says this error: An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll. Additional information: Input string was not in a correct format.

General-Doomer Over a year ago

what is input string throws exception?

|

Collectives™ on Stack Overflow

Extract all numbers in string to array

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related