Finding Blank Lines using regular expressions

In this regular expression we are going to find out blank lines. Means we are going to search lines containing only spaces (or Whitespace) and end of line.

Regular Expression Pattern

^\s*$

A description of the regular expression:

Beginning of line or string
Whitespace, any number of repetitions
End of line or string

How It Works

This regular expression will check for blank lines contains only spaces (Whitespace). Here we are going to search Beginning of line followed by Whitespace, any number of repetitions and End of line or string.

Read the rest of this entry »

Validate an email address using regular expressions

email address are the means of communication with people around the world. While processing forms email address validation plays an important. Proper email validation strengthen our contact list, ban spamming and protect us from robot form filling (Form AutoFill).

Here we are going to design a regular expression pattern to validate email address. which will check to make sure an e-mail address is a valid address, and in proper format means containing an username, at sign (@), and valid hostname. For example, admin@samplehost.com is valid, but SPAM@badhost is invalid. Most of email service provides limit the use of literals for email address creation. Only letters (a-z,A-Z), numbers (0-9), hyphens (-), underscore (_) and periods (.) are allowed and no special characters are accepted. You can add or remove any literals to your regular expression.

Regular Expression Pattern

^([a-zA-Z0-9_\-\.]+)@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$
 
email with IP -
^([a-zA-Z0-9_\-\.]+)@(([a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3}))|(([01]?\d\d?|2[0-4]\d|25[0-5])\.){3}([01]?\d\d?|25[0-5]|2[0-4]\d))$

For more information on Regular Expressions IP Address Validation with .net

Read the rest of this entry »

Regular Expressions IP Address Validation with .net

An Internet Protocol (IP) address is a numerical identification (logical address) that is assigned to devices participating in a computer network utilizing the Internet Protocol for communication between its nodes.

IP Address Classes:

IP addresses are categories into five classes: Class A, Class B, Class C, Class D and Class E. Each class allows for a range of valid IP addresses. whereas classes A, B and C are used to communication.

Class A Internet Protocol (IP) address ranges include 1.0.0.0 to 126.255.255.255. This class supports 16 million hosts on each of the 127 networks. network 0.0.0.0 is reserved for use as the default route and the network 127.0.0.0 is reserved for the “loopback” function.

Class B Internet Protocol (IP) address ranges include 128.1.0.0 to 191.255.255.255. This class supports 65,000 hosts on each of the 16,000 networks.

Class D Internet Protocol (IP) address ranges include 224.0.0.0 to 239.255.255.255. This class is used to support multicasting.

Class E Internet Protocol (IP) address ranges include 240.0.0.0 to 254.255.255.254. This class is used for experimentation. Class E networks have never been documented or utilized in a standard way.

IP addresses are also commonly used to divide networks into smaller ones. This concept is called subnetting. Subnet addresses include 255.0.0.0 to 255.255.255.255

Dotted-Decimal Notation

To make Internet addresses easier for people to read and write, IP addresses are often expressed as four decimal numbers, each separated by a dot. This format is called “dotted-decimal notation.” Dotted-decimal notation divides the 32-bit Internet address into four 8- bit fields and specifies the value of each field independently as a decimal number with the fields separated by dots.

Regular Expression Pattern

^(([01]?\d\d?|2[0-4]\d|25[0-5])\.){3}([01]?\d\d?|25[0-5]|2[0-4]\d)$

Read the rest of this entry »

Read and Display Data From an Excel File (.xsl or .xlsx) in ASP.NET

Microsoft Office Excel is a spreadsheet-application which a good mean to store data in spreadsheet in a table (tabular) form. In this article, we will see how to display data (retrive data or read data) from an Excel spreadsheet using ASP.NET.

We are reading an Excel file in ASP.NET. Our ASP page will be on remote server and an Excel file in our desktop. First of all we need to upload it to a remote server and then retrive the data. So we are design a form to upload an excel. There will be possibility that we have to retrive data from a file again and again so we will rename Excel and then upload it.

Read the rest of this entry »

Regular Expressions with .net – U.S. Social Security Numbers

In the United States, a Social Security number (abbreviated as SSN) is a nine-digit number issued to U.S. citizens, permanent residents, and temporary (working) residents. U.S. social security numbers are three sets of digits separated by hyphens; the first set contains three digits, the second set contains two digits, and the third set contains four digits. Its primary purpose is to track individuals for taxation purposes. In recent years the SSN has become a de facto national identification number. A properly formatted US social security number. first three digits must be 001 – 772.

Regular Expression Pattern

^((?!000)([0-6]\d{2}|[0-7]{2}[0-2]))-((?!00)\d{2})-((?!0000)\d{4})$

A description of the regular expression:

[1]: A numbered capture group. [(?!000)([0-6]\d{2}|[0-7]{2}[0-2])]
(?!000)([0-6]\d{2}|[0-7]{2}[0-2])
Match if suffix is absent. [000]
[2]: A numbered capture group. [[0-6]\d{2}|[0-7]{2}[0-2]]
Select from 2 alternatives
[0-6]\d{2}
Any character in this class: [0-6]
Any digit, exactly 2 repetitions
[0-7]{2}[0-2]
Any character in this class: [0-7], exactly 2 repetitions
Any character in this class: [0-2]
-
[3]: A numbered capture group. [(?!00)\d{2}]
(?!00)\d{2}
Match if suffix is absent. [00]
Any digit, exactly 2 repetitions
-
[4]: A numbered capture group. [(?!0000)\d{4}]
(?!0000)\d{4}
Match if suffix is absent. [0000]
Any digit, exactly 4 repetitions

Read the rest of this entry »