Displaying page
of
pages;
Items to
Title |
Test
Details
Pattern Title
|
Expression |
^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$ |
Description |
Email validator that adheres directly to the specification for email address naming. It allows for everything from ipaddress and country-code domains, to very rare characters in the username. |
Matches |
|
Non-Matches |
joe | @foo.com | a@a |
Author |
Rating:
Andy Smith
|
Title |
Test
Details
Pattern Title
|
Expression |
("[^"]*")|('[^\r]*)(\r\n)? |
Description |
Will match a VBScript string and/or comment
Ex:
' userinfo
strUsername = "tomsve"
iAge = 20
' temp
strPassword = "halloj"
...Would result in the following matches:
' userinfo
"tomsve"
' temp
"halloj"
Good luck!
Tom S. [email protected] |
Matches |
"my string" | "a string with ' in it" | ' comment |
Non-Matches |
asd " |
Author |
Rating:
Tom Svensson
|
Title |
Test
Details
Pattern Title
|
Expression |
[^A-Za-z0-9_@\.]|@{2,}|\.{5,} |
Description |
Used as a username validation script requires:
1. Allows All Alphanumeric characters & underscore
2. Allows One "@" character
3. Allows Five "." periods
4. Rejects spaces
|
Matches |
user name | user#name | ..... |
Non-Matches |
|
Author |
Rating:
Not yet rated.
Theo Tillotson
|
Title |
Test
Details
Pattern Title
|
Expression |
^[\w-]+(\.[\w-]+)*@([a-z0-9-]+(\.[a-z0-9-]+)*?\.[a-z]{2,6}|(\d{1,3}\.){3}\d{1,3})(:\d{4})?$ |
Description |
Matches a valid email address including ip's which are rarely used. Allows for a-z0-9_.- in the username, but not ending in a full stop i.e [email protected] is invalid and a-z0-9- as the optional sub domain(s) with domain name and a 2-7 char (a-z) tld allowing for short tld's like ca and new ones like museum. |
Matches |
|
Non-Matches |
|
Author |
Rating:
Not yet rated.
nick bennett
|
Title |
Test
Details
Pattern Title
|
Expression |
^DOMAIN\\\w+$ |
Description |
In response to a question on the regex list at www.aspadvice.com, this expression should ensure that a login field's username includes a 'DOMAIN\' prefix. The latter part of the expression should probably be limited so that it only allows usernames of appropriate lengths, perhaps 3 to 20 characters (by replacing + with {3,20} for instance). |
Matches |
DOMAIN\ssmith | DOMAIN\a | DOMAIN\username |
Non-Matches |
ssmith | username | DOMAIN\ |
Author |
Rating:
Not yet rated.
Steven Smith
|
Title |
Test
Details
Pattern Title
|
Expression |
(?!^[0-9]*$)(?!^[a-zA-Z]*$)^([a-zA-Z0-9]{6,15})$ |
Description |
I built this expression to test a string in ASP for valid username and password constraints. It can be adapted for any number of scenerios. For instance in this case, we needed to ensure the username someone wanted was not all numbers or all letters and was 6-15 characters in length with no special characters. This expression tests negatively for all number cases, then all letter cases, and lastly tests for only alphanumeric characters in the required range. In other words: the match must be alphanumeric with at least one number, one letter, and be between 6-15 character in length. |
Matches |
C2dfeed | sporttrak1 | 11223a |
Non-Matches |
pookie | d34_fff | 123456 |
Author |
Rating:
Pete Lindquist
|
Title |
Test
Details
Email
|
Expression |
^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$ |
Description |
regex to validate email address
noteworthy:
(1) It allows usernames with 1 or 2 alphanum characters, or 3+ chars can have -._ in the middle. username may NOT start/end with -._ or any other non alphanumeric character.
(2) It allows heirarchical domain names (e.g. [email protected]). Similar -._ placement rules there.
(3) It allows 2-9 character alphabetic-only TLDs (that oughta cover museum and adnauseum :>).
(4) No IP email addresses though -- I wouldn't Want to accept that kind of address. |
Matches |
|
Non-Matches |
|
Author |
Rating:
Rob Eberhardt
|
Title |
Test
Details
Pattern Title
|
Expression |
[^A-Za-z0-9] |
Description |
To detect non-alphanumeric characters (for new username/password validation, for instance):
monkey(AT)greyledge.net
14-Oct-2003 11:26 |
Matches |
!@#$ | %^&* | '><?.," |
Non-Matches |
ABC123abc | abc123ABC | abc0132ABC |
Author |
Rating:
meet zorrer
|
Title |
Test
Details
Pattern Title
|
Expression |
^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$ |
Description |
A short and sweet email address validator. Checks that the username starts and ends with an alphanumeric character, allows a few non-repeating 'special characters' (namely -, ., _, +, &) and checks for a sensible domain name (2-6 character TLD required). Some unconventional, yet technically valid, addresses will not be matched, but this is only a simple expression ;-) |
Matches |
|
Non-Matches |
|
Author |
Rating:
Luke Arms
|
Title |
Test
Details
Pattern Title
|
Expression |
^[^_][a-zA-Z0-9_]+[^_]@{1}[a-z]+[.]{1}(([a-z]{2,3})|([a-z]{2,3}[.]{1}[a-z]{2,3}))$ |
Description |
this pattern validates email address. it allows (1)numeric characters and underscore(_) in an address.(2)numeric characters in domain name. it doesn't match user names with a dot(.). doesn;t allow username starting or ending with @ underscore. they can be used in between |
Matches |
|
Non-Matches |
|
Author |
Rating:
Not yet rated.
Vijay Joshi
|
Title |
Test
Details
Email
|
Expression |
^[^_.]([a-zA-Z0-9_]*[.]?[a-zA-Z0-9_]+[^_]){2}@{1}[a-z0-9]+[.]{1}(([a-z]{2,3})|([a-z]{2,3}[.]{1}[a-z]{2,3}))$ |
Description |
Email-it is an extension to my previous expression for Validating email address.it has the following additional features: 1-username cant begin with a periods(.) and underscore(_) 2-maximum 2 periods(.) can be used in a username(previous xprsn didn't allowed any)(remember gmail which allows periods) |
Matches |
|
Non-Matches |
|
Author |
Rating:
Not yet rated.
Vijay Joshi
|
Title |
Test
Details
UserName
|
Expression |
^([a-z]{1,6}[ ']){0,3}([ÉÈÊËÜÛÎÔÄÏÖÄÅÇA-Z]{1}[éèëêüûçîôâïöäåa-z]{2,}[- ']){0,3}[A-Z]{1}[éèëêüûçîôâïöäåa-z]{2,}$ |
Description |
Pattern for user name input form validation <br />Expression pour tester la validité des noms propres lors de la validation des formulaires. <br />Syntaxe: <br />Les particules (de della, von, op, …..) peuvent être en minuscule <br />Après les particules doit apparaître un nom, écrit en minuscule, mais avec la première lettre en majuscule. <br />Les éléments du nom peuvent être séparés par un seul espace, un moins ou une apostrophe |
Matches |
"Houbart", "Dupont", "de Bonhomme", "della Faille d'Huisse", "Preud'homme"," van Wield" |
Non-Matches |
"123", "DUPONT", "dupont", "de (...more than one space...) Bonhomme",... |
Author |
Rating:
Not yet rated.
Jacques Houbart
|
Title |
Test
Details
Email validation
|
Expression |
^((([a-z]|[0-9]|!|#|$|%|&|'|\*|\+|\-|/|=|\?|\^|_|`|\{|\||\}|~)+(\.([a-z]|[0-9]|!|#|$|%|&|'|\*|\+|\-|/|=|\?|\^|_|`|\{|\||\}|~)+)*)@((((([a-z]|[0-9])([a-z]|[0-9]|\-){0,61}([a-z]|[0-9])\.))*([a-z]|[0-9])([a-z]|[0-9]|\-){0,61}([a-z]|[0-9])\.(af|ax|al|dz|as|ad|ao|ai|aq|ag|ar|am|aw|au|at|az|bs|bh|bd|bb|by|be|bz|bj|bm|bt|bo|ba|bw|bv|br|io|bn|bg|bf|bi|kh|cm|ca|cv|ky|cf|td|cl|cn|cx|cc|co|km|cg|cd|ck|cr|ci|hr|cu|cy|cz|dk|dj|dm|do|ec|eg|sv|gq|er|ee|et|fk|fo|fj|fi|fr|gf|pf|tf|ga|gm|ge|de|gh|gi|gr|gl|gd|gp|gu|gt| gg|gn|gw|gy|ht|hm|va|hn|hk|hu|is|in|id|ir|iq|ie|im|il|it|jm|jp|je|jo|kz|ke|ki|kp|kr|kw|kg|la|lv|lb|ls|lr|ly|li|lt|lu|mo|mk|mg|mw|my|mv|ml|mt|mh|mq|mr|mu|yt|mx|fm|md|mc|mn|ms|ma|mz|mm|na|nr|np|nl|an|nc|nz|ni|ne|ng|nu|nf|mp|no|om|pk|pw|ps|pa|pg|py|pe|ph|pn|pl|pt|pr|qa|re|ro|ru|rw|sh|kn|lc|pm|vc|ws|sm|st|sa|sn|cs|sc|sl|sg|sk|si|sb|so|za|gs|es|lk|sd|sr|sj|sz|se|ch|sy|tw|tj|tz|th|tl|tg|tk|to|tt|tn|tr|tm|tc|tv|ug|ua|ae|gb|us|um|uy|uz|vu|ve|vn|vg|vi|wf|eh|ye|zm|zw|com|edu|gov|int|mil|net|org|biz|info|name|pro|aero|coop|museum|arpa))|(((([0-9]){1,3}\.){3}([0-9]){1,3}))|(\[((([0-9]){1,3}\.){3}([0-9]){1,3})\])))$ |
Description |
This is a robust email validation: the username part conforms with RFC 2822 (for instance, emails with tags ("+") are validated).
The host part is checked for valid subdomains and its TLD is checked against all the 243 countries codes and the 14 ICANN'sTLDs. The host part also accepts IP with or without brackets. |
Matches |
|
Non-Matches |
|
Author |
Rating:
Philippe Benthien
|
Title |
Test
Details
URI Validation & Extraction
|
Expression |
^((http|https|ftp):\/\/)?((.*?):(.*?)@)?([a-zA-Z0-9][a-zA-Z0-9\-]{0,61}[a-zA-Z0-9])((\.[a-zA-Z0-9][a-zA-Z0-9\-]{0,61}[a-zA-Z0-9])*)(:([0-9]{1,5}))?((\/.*?)(\?(.*?))?(\#(.*))?)?$ |
Description |
Validates and extracts URI components.
Protocol is optional.
Username & Password is optional.
Host regex was taken from Remi Sabourin and follows RFC1035 except that it allows hostnames greater than 253 chars.
Also TLD length is not restriced.
Port number is optional.
Absolute Path is optional, and also extracts the optional querystring and optional anchor reference. |
Matches |
http://john:@www.domain.com:8080/index.html?param=value#Page1 |
Non-Matches |
http://www.domain.com:/ | www-.domain.com |
Author |
Rating:
Not yet rated.
John Bayly
|
Title |
Test
Details
Generic URI (RFC3986)
|
Expression |
(?<scheme>[a-zA-Z][a-zA-Z0-9\+\-\.]*):(?://(?:(?<username>(?:[a-zA-Z0-9_~!&',;=\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))+):?(?:[a-zA-Z0-9_~!&',;=\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*@)?(?<host>(?:[a-zA-Z0-9_~!&',;=\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*)(?::(?<port>[0-9]*))?(?<path>(?:/(?:[a-zA-Z0-9_~!&',;=:@\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*)*)|(?<path>/(?:(?:[a-zA-Z0-9_~!&',;=:@\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))+(?:/(?:[a-zA-Z0-9_~!&',;=:@\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*)*)?)|(?<path>(?:[a-zA-Z0-9_~!&',;=:@\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))+(?:/(?:[a-zA-Z0-9_~!&',;=:@\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*)*))?(?:\?(?<query>(?:[a-zA-Z0-9_~!&',;=:@/?\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*))?(?:\#(?<fragment>(?:[a-zA-Z0-9_~!&',;=:@/?\.\-\$\(\)\*\+]|(?:%[0-9a-fA-F]{2}))*))? |
Description |
Generic RFC3986 compliant hierarchical URI. Does not support IPv6 literal strings as hosts. Does not validate a host address against any registry types. Does not validate a URI structure against scheme constraints. Provides named groups for scheme(protocol), username, host, port, path, query, and fragment. |
Matches |
http://www.google.com telnet://172.16.1.1:80 ftp://ftp.rfc-editor.org/in-notes/rfc3986.txt https://testapp/application?kjj98734087234897 ftp://username@testapp/pub/upload http://testapp/function.asp#appload |
Non-Matches |
www.google.com http://www.google.com:www/ |
Author |
Rating:
AB Chalmers
|
Title |
Test
Details
Email
|
Expression |
([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$ |
Description |
This pattern validates email address. it allows (1)numeric characters and underscore(_) in an address.(2)numeric characters in domain name. it doesn't match user names with a dot(.). doesn;t allow username starting or ending with @ underscore. |
Matches |
|
Non-Matches |
|
Author |
Rating:
Not yet rated.
San
|
Title |
Test
Details
Email matcher
|
Expression |
([^_.]([a-zA-Z0-9_]*[.]?[a-zA-Z0-9_]+[^_]){2})@([a-z0-9]+[.]([a-z]{2,3}|[a-z]{2,3}[.][a-z]{2,3})) |
Description |
This is a cleanup of Vijay Joshi's "Email" pattern. It matches the same characters that his does, but matches them anywhere in the line. It adds useful substitution groups -- [1] - username portion of email (before @), [3] domain portion of email - after the @. It also was a bit overly-complex, so I reduced this as well.. Remember -- if you're planning to use this with something that uses 1003.2 BREs, you'll have to backquote + | ? ( ) { and }. |
Matches |
|
Non-Matches |
|
Author |
Rating:
Not yet rated.
Kamaji
|
Title |
Test
Details
Email (with Tags)
|
Expression |
([A-Z][\w\d\.\-]+)(?:(?:\+)([\w\d\.\-]+))?@([A-Z0-9][\w\.-]*[A-Z0-9]\.[A-Z][A-Z\.]*[A-Z]) |
Description |
I got tired of sites not recognising my Gmail account when I used tags, so I created this regexp which allows them to be included. Outputted variables are #1 - Username, #2 - Tag (or blank), #3 - Domain |
Matches |
|
Non-Matches |
a@nowhere |
Author |
Rating:
Not yet rated.
Luke Stevenson
|
Title |
Test
Details
Valid Usernames
|
Expression |
^([a-zA-Z])[a-zA-Z_-]*[\w_-]*[\S]$|^([a-zA-Z])[0-9_-]*[\S]$|^[a-zA-Z]*[\S]$ |
Description |
Will verify if the text is is in a valid user name format like: is alphanumeric, starts with an alphabet and contains no special characters other than underscore or dash. |
Matches |
username | user123 |user_123 | user-123 | username123_type |
Non-Matches |
123username | user name | _username |
Author |
Rating:
Farhan Sajjad
|
Title |
Test
Details
examples on storedprocedures
|
Expression |
getting username from empid |
Description |
LTER PROCEDURE [dbo].[usernamecheck]
@username varchar(50),
@loginID int = 0 OUTPUT
AS
SELECT @loginID = empid from emp
WHERE username=@username
if @@ROWCOUNT < 1
SELECT @loginID = 0
select @loginID
|
Matches |
storedprocedures |
Non-Matches |
not stored procedures |
Author |
Rating:
vasireddyveenavani
|
Displaying page
of
pages;
Items to