Examples for Regular Expressions

[Quali-Community]

 

Regular Expression	Pattern
\b\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}\b	IP
(0[1-9]|[12][0-9]|3[01])[-/.](0[1-9]|1[012])[-/.](19|20)\d\d	Date  indd-mm-yyyy  format
[-+]?[0-9]*\.?[0-9]+	Floating point number
^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$	Email address
([A-Z,a-z,0-9]*\.[A-Z,a-z,0-9]*)	File Name (name.extension)
\d	Digit (numeric)
\w	Character (letter, digit, underscore)
\r\n	Linebreak
\s	Whitespace

 

 A more detailed article with examples and common mistakes (and how to avoid them...) can be found here:

http://www.regular-expressions.info/examples.html">http://www.regular-expressions.info/examples.html

---

 (Quali) - 09/02/2012 01:42 PM

·  2625  ·

[Quali-Community]

Hi,

Please find below another regular expression that might come in handy :

Pattern	Regex
URL	^(https?:\/\/)?([\da-z\.-]+)\.([a-z\.]{2,6})([\/\w \.-]*)*\/?$

Thanks,

Oriel Belzer

---

Oriel Belzer (Oriel.B) - 10/21/2012 02:14 AM

·  2630  ·

[Quali-Community]

The problem with your IP address regex is that it will validate invalid IPs.  I use the following for IP validation:

 

(([0-9](?!\d)|[1-9][0-9](?!\d)|1[0-9]{2}(?!\d)|2[0-4][0-9](?!\d)|25[0-5](?!\d))[.]?){4}

• Breakdown:

Breakdown:

• ([0-9](?!\d)           Any single digit number
• |[1-9][0-9](?!\d)   Or any number 10-99
• |1[0-9]{2}(?!\d)   Or any number 100-199
• |2[0-4][0-9](?!\d) Or any number 200-250
• |25[0-5](?!\d)      Or any number 251-255
• [.]?                        And either 1 or 0 "."
• {4}                        All the above exactly 4 times.

This prevents fat fingering 10.10.40.120 into 10.10.401.20  and other mistakes like that.  

---

undefined (Quali) - 11/14/2012 12:25 PM

·  2629  ·

[Quali-Community]

Hello,

Why Regular expression   ^([0-9]{4})-([0-1][0-9])-([0-3][0-9])\s([0-1][0-9]|[2][0-3]):([0-5][0-9]):([0-5][0-9])$  forYYYY-MM-DD HH:MM:SS  in Testshell 4.8 is not valid ?

Thanks!

 

---

undefined (Quali) - 04/30/2013 05:54 AM

·  2628  ·

[Quali-Community]

Hi Xiao,

With small modifications, I was able to extract date-time from any string using your Regex expression:

In a transformation step, I used the following input in the Regular Expression field:

{'([0-9]{4})-([0-1][0-9])-([0-3][0-9])\s([0-1][0-9]|[2][0-3]):([0-5][0-9]):([0-5][0-9])'}

Notice that the string is wrapped with {' and '} to indicate a sting input.

I removed the ^ and the $ chars so I could match the date-time anywhere in the text:

 

 

Since you grouped the different elements of the date-time string, you can also extract this string to a date-time vector by clicking "Extract Groups":

---

undefined (tal.a) - 04/30/2013 07:23 AM

·  2627  ·

[Quali-Community]

Hi Tal,

Thanks! It's very useful!

---

undefined (Quali) - 04/30/2013 09:53 AM

·  2626  ·