Ignore all characters other than number digits and negative sign

[Joanne_Chang_LAX]

Currently I’m using this Regex code I found from other forums:

However, this also removes the negative sign, which I’ll need to be able to differentiate between positive value and negative value.
How can I be able to exclude the negative signs?

[postwick (Paul Ostwick)]

add -? at the beginning

[ppr (Peter Preuss)]

[ppr (Peter Preuss)]

when more thinking on amounts

Or

[Joanne_Chang_LAX]

Sorry, where do you mean by “the beginning”?

[Joanne_Chang_LAX]

Sorry I’m not familiar with those expressions, I would like to ignore the commas, would this ignore or include the commas?

[postwick (Paul Ostwick)]

The beginning of your regex expression.

[ppr (Peter Preuss)]

[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…

for prototypes: https://regex101.com/

@Joanne_Chang_LAX

would like to ignore the commas

go for the first pattern or

[Joanne_Chang_LAX]

@postwick

-?

Like this? This didn’t work

[ppr (Peter Preuss)]

@ppr

go for

keep in mind: \-?\d+ is used for match and not for replace as shown in the screenshots

As replace can have side effects when input text can be like:

[Joanne_Chang_LAX]

Like this? This also didn’t work

[Joanne_Chang_LAX]

[ppr (Peter Preuss)]

we shared the cheatsheet with you
…Regex.Match(…).Value

[postwick (Paul Ostwick)]

You realize Regex.Replace replaces the matched characters with what’s in the third string which in your case is “” right?

Are you trying to extract the number, including the - character? Or are you trying to erase all digits and the - sign, which is what your Replace statement is meant for?