I want regular expression for only AUD $ for the currency field?

Deepika61
Tera Contributor

Hi All,

Actually on Record producer , for currency field i have created one Regular expression , but it allows only $ and numbers, but i want like  "AUD $", it only allows those three letters before $, after that only numbers?

 

Please help me on this

Thanks

Deepika

Deepika61_0-1699029886218.png

 

1 ACCEPTED SOLUTION

Peter Bodelier
Giga Sage

Hi @Deepika61,

 

Simply add AUD in front of the $ sign:

 

^AUD\$[+-]?[0-9]{1,3}(?:,?[0-9]{3})*(?:\.[0-9]{2})?$

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

1 REPLY 1

Peter Bodelier
Giga Sage

Hi @Deepika61,

 

Simply add AUD in front of the $ sign:

 

^AUD\$[+-]?[0-9]{1,3}(?:,?[0-9]{3})*(?:\.[0-9]{2})?$

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.