Solved

check money in regex

Posted on 2013-01-30
3
195 Views
Last Modified: 2013-02-14
I want to check if it is a good $ amount and txtpriceamount can not be blank.  It could also be a negative number.  txtpriceamount is required.

10.00 yes
1.00 yes
0.00 yes
0.02 yes
0.00 yes

-10.00 yes
-1.00 yes
-0.00 yes
-0.02 yes
-0.00 yes


1 no
text is no




 <asp:TextBox ID="txtpriceamount" runat="server"></asp:TextBox>
              &nbsp;<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
                    ControlToValidate="txtpriceamount" ErrorMessage="Incorrect Amount" ValidationExpression="^[1-9]+\d*\.\d{2}$"></asp:RegularExpressionValidator>
                &nbsp;
0
Comment
Question by:VBdotnet2005
  • 2
3 Comments
 
LVL 41

Accepted Solution

by:
guru_sami earned 250 total points
Comment Utility
Are those the only numbers you want or you want to have any valid money value?

Here's one:
^-?(\d{1,3}(\,\d{3})*|(\d+))(\.\d{2})$

Open in new window


All below will be valid. But it can be adjust to your requirement.

10.00
1.00
0.00
0.02
0.00
-10.00
-1.00
-0.00
-0.02
-0.00
100.00
1000.00
10,000.00
100,000.00

This  will not allow commas:
^-?([1-9]\d*|(\d+))(\.\d{2})$

Open in new window


FYI: Try tool like Expresso for creating/testing regexs..
0
 
LVL 29

Assisted Solution

by:Kumaraswamy R
Kumaraswamy R earned 250 total points
Comment Utility
This worked too.
 
^\$?[0-9]+(,[0-9]{3})*(\.[0-9]{2})?$
0
 
LVL 41

Expert Comment

by:guru_sami
Comment Utility
For the "txtpriceamount can not be blank.":

You simply add a RequireFieldValidator for the textbox in addition to your ReqFieldValidator.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now