Regular expression for negative amounts

[A_Learner]

Hi,
Using regular expressions, I need to replace any text in the amount field preserving optional minus sign, commas and decimal points.

I am doing this with System.Text.RegularExpressions.Regex.Replace(Amount, “[^0-9,.]+”,“”)

But this is not preserving minus sign. Can you help?

Thank you,

[Praveen_Mudhiraj]

Can you provide sample

@A_Learner

[Palaniyappan (Palaniyappan P)]

Hi

Try with this expression

System.Text.RegularExpressions.Regex.Replace(Amount, “[\-]”, “”)

Cheers @A_Learner

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @A_Learner ,
Can you share input and expect output?
regards,

[tazunnisa.badavide (Taj)]

can u share the input value !Additionally,try to add the minus sign in the regular expression using slash

[Praveen_Mudhiraj]

You can try expression… So it will remove all the special characters

System.Text.RegularExpressions.Regex.Replace(Amount,“[^0-9]+“,””)

@A_Learner

[A_Learner]

Input: TOTAL AMOUNT -$1,161.09

Output: -1,161.09

Thank you,

[Praveen_Mudhiraj]

System.Text.RegularExpressions.Regex.Replace(Amount,“[^0-9]+“,””)

@A_Learner … You can try with this

[tazunnisa.badavide (Taj)]

@A_Learner

Regex for the output u mentioned
(?<=TOTAL AMOUNT\s*)[-0-9$,.]+

[Praveen_Mudhiraj]

It will replace all the characters expect the digits

@A_Learner

[A_Learner]

@A_Learner

System.Text.RegularExpressions.Regex.Replace(Amount, “[^0-9,.]+”,“”)

Updated the above to include minus sign. Working good. Many Thanks.