Email Password Remember me?  Lost your password?

• Download source files - 71.2 Kb
• Download demo project - 31.6 Kb

Introduction

Regular expressions are the best and the easiest way to do data validation. If you want to check for a valid date, then programming for it will be very complicated. A simple solution is to create a regular expression for what you need, and compare the input with the expression itself. Regular expressions are very powerful as they can reduce the size of the code and are also easy to understand.

The regular expression validator attached with this article allows users to create their own rules and then check for its validity.

If you see the source files, you will find the use of Datatable, XML and RegEx for achieving this task. This combination will work for large databases. But if you want to simplify the code, the Datatable can be removed and all the working can be directly performed through XML and RegEX.

The validation rules can be made for three basic data types: Date, Number and String. The rules can be used efficiently to make sure that the data is entered in correct format.

The code can be used in any application for comparing records so that the data entered is what we require. The use of XML makes it easier for storing the validation rules.

Using the code

Classes have been created for each data type to make it easier to handle. The user does not have to bother about the class. This classes are used for generating the regular expression, and in turn the XML for the rule selected by the user. The user just has to pass the XML string and the records get validated.

Data types

• STRING

  You can specify the characters allowed in the string i.e., upper/lower case, special characters and whether to include space or not. Valid/invalid characters can be specified. The valid character means, it is acceptable and invalid means not allowed.

• NUMBER

  It is possible to specify numbers in the rule including the maximum and minimum value for it. Currency symbols can also be checked by specifying the symbol. The position of the currency symbol can also be specified i.e., prefix or suffix.

• DATE

  The date format can also be specified in the order of day, month and year. You can also specify the 1 or 01 pattern for day and month. The range can also be specified. The date has to be between the two dates that are specified in the range.

• NONE

  Everything will be allowed, ignoring the invalid characters (if specified).

All the comparison is performed using regular expressions i.e., regular expressions are generated for the rules.

How to use the application

Follow these steps:

• Select the data type for which you want to create the rule.
• If String, then specify the characters that you want to allow (all characters, all numbers or all characters & numbers). Whether you want to allow space or not, can also be specified. Specify any valid / invalid character (optional).
• If Number, specify the currency symbol, its position (prefix/suffix) and the decimal values allowed.
• Press OK to generate the rule (i.e., the regular expression).
• Enter the value to the textbox provided at the bottom, and press CHECK.
• If the value entered matches the regular expression, relevant message will be shown at the bottom of the application. Also, if there are any errors, then these errors will be notified at the bottom of the application.

You must Sign In to use this message board.

Per page 102550

FirstPrevNext

can't see regular expression halibut8763 8:02 20 Jul '07   You wrote the following as responses to people not being able to see the regular expression: July 25 2006: (reply to satesh) The application which is uploaded [with the source code] will give you the regular expression. I have not shown it on the sample application. I don't know why..... Jul 13, 2005: (reply to korell) The regular expression is created and stored in the memory. I have not displayed. Do you need that..??? I still don't understand how to get the regular expression. Please give a step by step answer for how to find the generated regular expression Note: I downloaded this application to help generate regular expressions for me. thanks Sign In·View Thread·PermaLink 5.00/5 Regular Expression Dewang Ajmera. 22:08 8 Jan '07   If i have one String which should Contain One Number One Alphabet and One Special Character than how do i Validate the String. Thanking you, Dewang Ajmera. Sign In·View Thread·PermaLink Where in the Regular expression satesh 21:32 19 Jul '06   You have done nice work. I want to see and refer regular expression. Pl. tell me how i can see that. Pl. Satesh 0 Sign In·View Thread·PermaLink Re: Where in the Regular expression Vasant Raj 3:37 25 Jul '06   The application which is uploaded [with the source code] will give you the regular expression. I have not shown it on the sample application. I don't know why..... Sign In·View Thread·PermaLink 2.00/5 Where is the regular expression? korell 11:31 13 Jul '05   Seems like a nice little program, but can I find the generated regular expression? In the textbox at the bottom it just says: "RESULT:-Regular Expression Generated...", but where is it? Thanks, Sacha Sign In·View Thread·PermaLink 2.33/5 Re: Where is the regular expression? Vasant Raj 18:05 13 Jul '05   The regular expression is created and stored in the memory. I have not displayed. Do you need that..??? Sign In·View Thread·PermaLink 2.00/5 Regular Expression Mehul__Patel 22:15 6 Mar '05   Good work man! How can I validate the Phone number. I mean which data type should I choose? Sign In·View Thread·PermaLink 1.50/5 Re: Regular Expression Vasant Raj 22:57 6 Mar '05   phone number is usually numeric 11111111111 u can use integer datatype. If you want to allow special characters like () for city code then you can select string datatype and specify '(' & ')' as valid characters. Sign In·View Thread·PermaLink 2.00/5

Last Visit: 2:34 23 Nov '09     Last Update: 2:34 23 Nov '09 1