Displaying page
of
pages;
Items to
| Title |
Test
Details
Pattern Title
|
| Expression |
^[A-Z0-9]{8}-[A-Z0-9]{4}-[A-Z0-9]{4}-[A-Z0-9]{4}-[A-Z0-9]{12}$ |
| Description |
GUID Tester. It tests SQL Server GUIDs, which are alphanumeric characters grouped 8-4-4-4-12 (with the dashes). Make sure they don't have the brackets around them before you check them and have fun! |
| Matches |
4D28C5AD-6482-41CD-B84E-4573F384BB5C | B1E1282C-A35C-4D5A-BF8B-7A3A51D9E388 | 91036A4A-A0F4-43F0-8CD |
| Non-Matches |
{B1E1282C-A35C-4D3A-BF8B-7A3A51D9E388} | AAAAAAAAAAAAAAAAA | B;E1282C-A35C-4D3A-BF8B-7A3A51D9E38 |
| Author |
Rating:
Not yet rated.
James Bray
|
| Title |
Test
Details
Pattern Title
|
| Expression |
20\d{2}(-|\/)((0[1-9])|(1[0-2]))(-|\/)((0[1-9])|([1-2][0-9])|(3[0-1]))(T|\s)(([0-1][0-9])|(2[0-3])):([0-5][0-9]):([0-5][0-9]) |
| Description |
Sql date format tester. |
| Matches |
2099-12-31T23:59:59 | 2002/02/09 16:30:00 | 2000-01-01T00:00:00 |
| Non-Matches |
2000-13-31T00:00:00 | 2002/02/33 24:00:00 | 2000-01-01 60:00:00 |
| Author |
Rating:
Peter Pfeifer
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^((((([13578])|(1[0-2]))[\-\/\s]?(([1-9])|([1-2][0-9])|(3[01])))|((([469])|(11))[\-\/\s]?(([1-9])|([1-2][0-9])|(30)))|(2[\-\/\s]?(([1-9])|([1-2][0-9]))))[\-\/\s]?\d{4})(\s((([1-9])|(1[02]))\:([0-5][0-9])((\s)|(\:([0-5][0-9])\s))([AM|PM|am|pm]{2,2})))?$ |
| Description |
This expression can be used validate a datetime column from SQL Server. Big parts of it where taken from other samples on RegexLib. Please feel free to take it apart and improve it. |
| Matches |
3/3/2003 | 3/3/2002 3:33 pm | 3/3/2003 3:33:33 am |
| Non-Matches |
13/1/2002 | 3/3/2002 3:33 | 31/3/2002 |
| Author |
Rating:
Not yet rated.
Scott Watermasysk Watermasysk
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(^([0-9]|[0-1][0-9]|[2][0-3]):([0-5][0-9])(\s{0,1})(AM|PM|am|pm|aM|Am|pM|Pm{2,2})$)|(^([0-9]|[1][0-9]|[2][0-3])(\s{0,1})(AM|PM|am|pm|aM|Am|pM|Pm{2,2})$) |
| Description |
Validate “Time” Data to Work with SQL Server
This is a fix (I hope) for a problem with the original expression. It originally allowed any combination of am or pm. For example: ma, aa, mm, mp, etc. |
| Matches |
8am | 8 am | 8:00 am |
| Non-Matches |
8a | 8 a | 8:00 a |
| Author |
Rating:
Not yet rated.
Greg Burns
|
| Title |
Test
Details
Pattern Title
|
| Expression |
([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) |
| Description |
Checks for Date in the typical MySQL DB Format. Not mutch but simple to for converting to German date format:
$date = "2003-12-03";
if (ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})", $date, $regs))
{
echo "$regs[3].$regs[2].$regs[1]"; // prints 03.12.2003
} |
| Matches |
2002-11-03 | 2007-17-08 | 9999-99-99 |
| Non-Matches |
2002/17/18 | 2002.18.45 | 18.45.2002 |
| Author |
Rating:
Not yet rated.
Mike T Spike
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(([0-1][0-9])|([2][0-3])):([0-5][0-9]):([0-5][0-9]) |
| Description |
Validates time in MySQL time format. 24 hour time colon seperated hours:minutes:seconds |
| Matches |
09:30:00 | 17:45:20 | 23:59:59 |
| Non-Matches |
24:00:00 |
| Author |
Rating:
Patrick O'Hara
|
| Title |
Test
Details
Pattern Title
|
| Expression |
((^(10|12|0?[13578])([/])(3[01]|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(11|0?[469])([/])(30|[12][0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(2[0-8]|1[0-9]|0?[1-9])([/])((1[8-9]\d{2})|([2-9]\d{3}))$)|(^(0?2)([/])(29)([/])([2468][048]00)$)|(^(0?2)([/])(29)([/])([3579][26]00)$)|(^(0?2)([/])(29)([/])([1][89][0][48])$)|(^(0?2)([/])(29)([/])([2-9][0-9][0][48])$)|(^(0?2)([/])(29)([/])([1][89][2468][048])$)|(^(0?2)([/])(29)([/])([2-9][0-9][2468][048])$)|(^(0?2)([/])(29)([/])([1][89][13579][26])$)|(^(0?2)([/])(29)([/])([2-9][0-9][13579][26])$)) |
| Description |
This Validator Validates any date from 1800 - 9999. It takes special care of Leap years and validates any format of type mm/dd/yyyy , m/dd/yyyy , mm/d/yyyy , m/d/yyyy.
Since SQL Server does not accept any date before 1/1/1753, so i hope it will meet Your Requirements.(Modified Version of Jason West's Date Validator.) |
| Matches |
2/2/2000 | 02/02/2000 | 02/2/2000 |
| Non-Matches |
2.2.2000 | 2-2-2000 |
| Author |
Rating:
Saurabh Nath
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(NOT)?(\s*\(*)\s*(\w+)\s*(=|<>|<|>|LIKE|IN)\s*(\(([^\)]*)\)|'([^']*)'|(-?\d*\.?\d+))(\s*\)*\s*)(AND|OR)? |
| Description |
Heres my sql clause parser regexp for recordset filtering. Does recursive query parsing all by its self. Only problem I cant figure is how to match comma separated lists of quoted strings. Tell me if you figure out how!
The unicodes in the re was put in by the entry form please replace them with their ascii equivalents to use it. |
| Matches |
Aeroplane LIKE 767 | Movie LIKE 'Star' AND NOT Movie LIKE 'Trek' | Number IN (1,2,3,4,5) |
| Non-Matches |
Hello there | A=EXCELLENT OR | B!=POOR |
| Author |
Rating:
Not yet rated.
Joseph Warwick
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^(((((0[13578])|([13578])|(1[02]))[\-\/\s]?((0[1-9])|([1-9])|([1-2][0-9])|(3[01])))|((([469])|(11))[\-\/\s]?((0[1-9])|([1-9])|([1-2][0-9])|(30)))|((02|2)[\-\/\s]?((0[1-9])|([1-9])|([1-2][0-9]))))[\-\/\s]?\d{4})(\s(((0[1-9])|([1-9])|(1[0-2]))\:([0-5][0-9])((\s)|(\:([0-5][0-9])\s))([AM|PM|am|pm]{2,2})))?$ |
| Description |
Following expression can be used to validate a datetime column from SQL Server. This expression is an enhanced version of Scott Watermasysk's date/time submission. It now accepts leading zeros in months, days, and hours. In addition, this expression properly handles the 11th hour. Watermasysk's would take the 10th and 12th hour but not the 11th. This regex has been tweaked to do so. Does not handle the February 29th problem on non-leap years yet. Will learn a little more about RegEx and do so in later submission.
|
| Matches |
11/30/2003 10:12:24 am | 2/29/2003 08:14:56 pm | 5/22/2003 |
| Non-Matches |
11/31/2003 10:12:24 am | 2/30/2003 08:14:56 pm | 5/22/2003 14:15 |
| Author |
Rating:
Not yet rated.
David Darling
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^((((((0?[13578])|(1[02]))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\-\/\s]?((0?[1-9])|([1-2][0-9]))))[\-\/\s]?\d{2}(([02468][048])|([13579][26])))|(((((0?[13578])|(1[02]))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\-\/\s]?((0?[1-9])|(1[0-9])|(2[0-8]))))[\-\/\s]?\d{2}(([02468][1235679])|([13579][01345789]))))(\s(((0?[1-9])|(1[0-2]))\:([0-5][0-9])((\s)|(\:([0-5][0-9])\s))([AM|PM|am|pm]{2,2})))?$ |
| Description |
This regex will match SQL Server datetime values, allowing date only, allowing zero padded digits in month, day and hour, and will match leap years from 1901 up until 2099. |
| Matches |
2/29/2004 | 04/01/2003 10:01:23 am | 03-20-1999 |
| Non-Matches |
2/29/2003 | 13/30/2001 10:05:00 pm | 12/32/2003 |
| Author |
Rating:
Not yet rated.
Sung Lee
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^((\d{2}(([02468][048])|([13579][26]))[\-\/\s]?((((0?[13578])|(1[02]))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\-\/\s]?((0?[1-9])|([1-2][0-9])))))|(\d{2}(([02468][1235679])|([13579][01345789]))[\-\/\s]?((((0?[13578])|(1[02]))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\-\/\s]?((0?[1-9])|([1-2][0-9])|(30)))|(0?2[\-\/\s]?((0?[1-9])|(1[0-9])|(2[0-8]))))))(\s(((0?[1-9])|(1[0-2]))\:([0-5][0-9])((\s)|(\:([0-5][0-9])\s))([AM|PM|am|pm]{2,2})))?$ |
| Description |
Matches ANSI SQL date format YYYY-mm-dd hh:mi:ss am/pm. You can use / - or space for date delimiters, so 2004-12-31 works just as well as 2004/12/31. Checks leap year from 1901 to 2099. |
| Matches |
2004-2-29 | 2004-02-29 10:29:39 pm | 2004/12/31 |
| Non-Matches |
2003-2-29 | 2003-13-02 | 2003-2-2 10:72:30 am |
| Author |
Rating:
Sung Lee
|
| Title |
Test
Details
Quoted string
|
| Expression |
^(\x22|\x27)((?!\1).|\1{2})*\1$ |
| Description |
The regex validate a quoted string in VBScript or Ansi SQL. The string may contain the containing quote character if it is escaped by being doubled up.
In VB/VBScript two double quotes within a string enclosed in double qoutes translate into one double quote within the string
In SQL two single quotes within a string enclosed in single qoutes translate into one single quote within the string |
| Matches |
"To quote Yoda (""Do, or do not. There is no 'try'"" )" |
| Non-Matches |
'This won't validate' | "He said "Ok."" |
| Author |
Rating:
Not yet rated.
Michael Ash
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^(20|21|22|23|[01]\d|\d)(([:.][0-5]\d){1,2})$ |
| Description |
24 hour clock as prefered by MS-SQL, allows for shorter more human methods of writing time (no preceding zero or seconds required).
MS-SQL prefers semi-colon although this accepts full stops for users ease of use. |
| Matches |
09:00:00 | 09.00 | 9:00 |
| Non-Matches |
9:00AM |
| Author |
Rating:
Not yet rated.
Adam Smith
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^((?-i:0x)?[A-Fa-f0-9]{32}|
[A-Fa-f0-9]{8}-[A-Fa-f0-9]{4}-[A-Fa-f0-9]{4}-[A-Fa-f0-9]{4}-[A-Fa-f0-9]{12}|
\{[A-Fa-f0-9]{8}-[A-Fa-f0-9]{4}-[A-Fa-f0-9]{4}-[A-Fa-f0-9]{4}-[A-Fa-f0-9]{12}\})$ |
| Description |
Validates a GUID/UUID, without capture, to the following patterns: [{hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh}],
[hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh],[hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh],[0xhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh], where 'h' is a valid hex character. This last pattern is a binary format commonly used with SQL Server 2000. It allows you to use binary(n) and varbinary(n) parameters that convert well to unique identifier. Please note that this is not case sensitive EXCEPT the 'x' in the binary pattern. It must be lower case. |
| Matches |
6F9619FF-8B86-D011-B42D-00C04FC964FF | 0x6F9619FF8B86D011B42D00C04FC964FF | {6F9619FF-8B86-D011-B42D |
| Non-Matches |
{6F9619FF8B86D011B42D00C04FC964FF} | 0X6F9619FF8B86D011B42D00C04FC964FF |
| Author |
Rating:
Patrick Fogarty
|
| Title |
Test
Details
Pattern Title
|
| Expression |
\{[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}\} |
| Description |
This matches the specific value for a unique identifier (GUID) from SQL server. Written by Jason N. Gaylord. |
| Matches |
{A2B95C88-F211-4A2B-9729-2CFAB45C8984} | {A2B95C88-F211-4A2B-9729-2CFAB45C8123} | {A2B95C88-F211-4A2 |
| Non-Matches |
A2B95C88-F211-4A2B-9729-2CFAB45C8984 | A2B95C88F2114A2B9729-2CFAB45C8984 | 123456a |
| Author |
Rating:
Jason N. Gaylord
|
| Title |
Test
Details
Pattern Title
|
| Expression |
^[a-zA-Z_]{1}[a-zA-Z0-9_@$#]*$ |
| Description |
This Regex matches valid SQL identifiers, including names for Stored Procedures and the like. Note that local variables/parameters (which begin with an "@") will not match this Regex, nor will temporary objects (beginning with a "#"), or global temporary objects (beginning with "##"). All other valid identifiers/variables/table names/stored procedure names/columns etc., will match. Please let me know if you find this useful or have any complaints - [email protected]. |
| Matches |
upApplicationReadContacts | _Application_ReadContacts | a_45$#z |
| Non-Matches |
upApplication ReadContacts | $Application_ReadContacts | a_45%$#z |
| Author |
Rating:
Geoff Williams
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(((0[1-9]|[12][0-9]|3[01])([.])(0[13578]|10|12)([.])([1-2][0,9][0-9][0-9]))|(([0][1-9]|[12][0-9]|30)([.])(0[469]|11)([.])([1-2][0,9][0-9][0-9]))|((0[1-9]|1[0-9]|2[0-8])([.])(02)([.])([1-2][0,9][0-9][0-9]))|((29)(\.|-|\/)(02)([.])([02468][048]00))|((29)([.])(02)([.])([13579][26]00))|((29)([.])(02)([.])([0-9][0-9][0][48]))|((29)([.])(02)([.])([0-9][0-9][2468][048]))|((29)([.])(02)([.])([0-9][0-9][13579][26]))) |
| Description |
Usefull for SQL update and insert sentence.. |
| Matches |
01.01.2004 | 30.12.2005 |
| Non-Matches |
01/01/2004 | 1.1.2004 | 01-01-2004 |
| Author |
Rating:
Pavel Rotar
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(?:Provider="??(?<Provider>[^;\n]+)"??[;\n"]??|Data\sSource=(?<DataSource>[^;\n]+)[;\n"]??|Initial\sCatalog=(?<InitialCatalog>[^;\n]+)[;\n"]??|User\sID=(?<UserID>[^;\n]+)[;\n"]??|Password="??(?<Password>[^;\n]+)"??[;\n"]??|Integrated\sSecurity=(?<IntegratedSecurity>[^;\n]+)[;\n]??|Connection\sTimeOut=(?<ConnectionTimeOut>[^;\n]+)[;\n"]??)+$ |
| Description |
This RegExp is degigned to mach SQL OLEDB Connection String to the Named Groups Properties useful for .Net MATCH EXAMPLE(the submition field is too short):Provider="SQLOLEDB.1";Data Source=(local);Initial Catalog=master;User ID=sa;Password="SA_PASS";Connection TimeOut=90 |
| Matches |
Provider="SQLOLEDB.1";Data Source=(local);Initial Catalog=master;User ID=sa;Password=" |
| Non-Matches |
Any non SQL Connection String |
| Author |
Rating:
Jordan Ilchev
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(?=(?:[^\']*\'[^\']*\')*(?![^\']*\')) |
| Description |
This exp will parse out space delimited strings with consideration to single quotes. I use it with SQL statements. |
| Matches |
BETWEEN '11/1/2004' AND '12/1/2004 11:59:59 PM' |
| Non-Matches |
flabberguasted |
| Author |
Rating:
Not yet rated.
Scott Richardson
|
| Title |
Test
Details
Pattern Title
|
| Expression |
(SELECT\s[\w\*\)\(\,\s]+\sFROM\s[\w]+)|
(UPDATE\s[\w]+\sSET\s[\w\,\'\=]+)|
(INSERT\sINTO\s[\d\w]+[\s\w\d\)\(\,]*\sVALUES\s\([\d\w\'\,\)]+)|
(DELETE\sFROM\s[\d\w\'\=]+) |
| Description |
This RE match the SQL Basics Queries (SELECT, UPDATE, INSERT and DELETE). |
| Matches |
SELECT * FROM TABLE | UPDATE TABLE SET FIELD=VALUE WHERE ID_FIELD=VALUE_ID | DELETE FROM TABLE WHERE |
| Non-Matches |
SELECT TABLE | UPDATE SET TABLE | INSERT INTO FIELD=VALUE TABLE |
| Author |
Rating:
Gabriel Fróes
|
Displaying page
of
pages;
Items to
