Filter your text with System.Text.RegularExpressions.Regex.Matches(MyText, "\d+(\.\d+)*"), where MyText is the text you’ve extracted. Then each match can be converted to a double if need be, but will only contain 1100.01, 520.00, and 503.00 as shown in your example above.
I seem to be getting more errors when changing the variable to string.
Let me add some more info may help clear things up a bit, right so am using get text to extract the figure, which when am storing the data its in a generic variable as its picking up the currency.
I then want to put the figure without the currency sign in an if statement to say ‘Amount > 500’ then do this else do this.
Because its picking up the currency everytime, the bot keeps going down the ‘else’ line
The System.Text.RegularExpressions…etc. should be assigned to a variable of type MatchCollection. You can the iterate over this collection to get the value of each match. If item is one of the items in the collection, you can get the string you want from item.Value.