Regular expression to get number from string

[ppr (Peter Preuss)]

@Sarah_Tang
give a try on

and refer on groups

(\d+\.?)(?:\,?)(\d+)

As an alternate: catch also comma and replace it afterwards

>Regex.Matches("(* 10.00_) (* 22,000_)","[\d,.]+").Cast(Of Match).Select(Function (m) m.Value.Replace(",","")).toArray
<- string[2] { "10.00", "22000" }

Following your direction for replacing the unwanted you can try:

For some additional starter help have a look here:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…