Validating Data using Regular Expressions
Regular expression is a string that is used to describe or match a set of strings, according to certain syntax rules.
Regular expressions are used by many text editors, utilities, and programming languages to search and manipulate text based on patterns. For example, Perl and Tcl have a powerful regular expression engine built directly into their syntax. Several utilities provided by Unix distributions—including the editor ed and the filter grep—were the first to popularize the concept of regular expressions. “Regular expression” is often shortened to regex or regexp (singular), or regexes, regexps, or regexen (plural). Some authors distinguish between regular expression and abbreviated forms such as regex, restricting the former to true regular expressions, which describe regular languages, while using the latter for any regular expression-like pattern, including those that describe languages that are not regular. As only some authors observe this distinction, it is not safe to rely upon it.
As an example of the syntax, the regular expression \bex can be used to search for all instances of the string “ex” that occur at word boundaries (signified by the \b). Thus in the string, “Texts for experts,” \bex matches the “ex” in “experts,” but not in “Texts” (because the “ex” occurs inside the word there and not immediately after a word boundary).
Source: Wikipedia.
For more information on regular expressions please visit: www.regularexpression.info
Most of regular expressions were taken from www.regexlib.com. We are not able to include full list of contributors because it is too big. We did our best to test and modify if necessary pattern strings however as time goes by standards changes and some of them could became no longer valid. Therefore Regular Expression Validation Rules should be used with caution. If you have any useful Regular expressions please ETL Forum we would be more than happy to include it into the next release.
To change Validation Function properties double click on it
Regular Expression
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates data against regular expression |
| Properties |
Is IP Address V4
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates IP addresses in the dotted quad form |
| Properties | Default |
| Pass | 192.168.1.1, 10.2.234.1, 66.129.71.122 |
| Fail | 192.168.1, 10.2.1234.1, 66 129 71 122 |
IP Address V6
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates all IPv6 text representations as defined within RFC 2373 |
| Properties | Default |
| Pass | ::0:0:0:FFFF:129.144.52.38, FEDC:BA98::3210:FEDC:BA98:7654:3210, ::13.1.68.3 |
| Fail | FEDC:BA98:7654:3210:FEDC:BA98:7654:3210:1234,3210:FEDC:BA98:7654:3210:1234, :FEDC:BA98:7654:3210: |
Is Email
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Email Address validation that allows both IP addresses and regular domains. In the case of an IP address it makes sure that it is no more than 255 for each part. |
| Properties | Default |
| Pass | john@doe.com, john-doe@255.255.255.255, john.doe@john.doe.com |
| Fail | john@doe, john-doe@999.999.999.999, @john.doe.com |
Is ISBN 10
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of 10 digits ISBN. The ISBN number must be preceded by the text “ISBN:” or “ISBN-10:”, the colon is optional. |
| Properties | Default |
| Pass | ISBN-10: 0-93028-923-4 |
| Fail | ISBN-13: 978-0-5960-0289-3 |
Is ISBN 13
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of new 13 digits ISBN. The ISBN number must be preceded by the text “ISBN:” or “ISBN-13:”, the colon is optional. |
| Properties | Default |
| Pass | ISBN-13: 978-0-5960-0289-3 |
| Fail | ISBN-10: 0596002890 |
Is Credit Card
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of all major credit cards formats |
| Properties | Default |
| Pass | 341-1111-1111-1111, 5431-1111-1111-1111, 30569309025904 |
| Fail | 30-5693-0902-5904, 5631-1111-1111-1111, 31169309025904 |
Is URL
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of URL |
| Properties | Default |
| Pass | https://www.download.com |
| Fail | https://999.999.999.999/dfd |
Is UNC
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of UNC |
| Properties | Default |
| Pass | \\\\server\c$ |
| Fail | server |
Is File Name
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of file name format, file name must have a drive letter and an extension |
| Properties | Default |
| Pass | c:\1.txt |
| Fail | ftc |
Is UK Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates United Kingdom Post Code |
| Properties | Default |
| Pass | SW1W 8EU |
| Fail | SW1WK8EU |
Is UK VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | United Kingdom VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | GB123123412, GBGD123, 123123412123 |
| Fail | GB1231234124, GBGD1234, 023 1234 12 123 |
Is UK Bank Sort Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of United Kingdom Bank Sort code |
| Properties | Default |
| Pass | 09-01-29, 05-06-25 |
| Fail | 90125 |
Is UK Vehicle Registration Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of United Kingdom Vehicle registration Number |
| Properties | Default |
| Pass | ABC 123 A, A 123 ABC, AB 12 ABC |
| Fail | AB 123 C, A 123 AB, AB 12 AB |
Is UK Driver License
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates the United Kingdom Drivers License format as described by the DVLA |
| Properties | Default |
| Pass | JOHNS711215GG9SY |
| Fail | JOHNS731215GG9SY |
https://www.govtalk.gov.uk/gdsc/html/frames/default.htm.
Matches:
- Must be 16 characters
- First 5 characters are alphanumeric.
- Next 6 characters must be numeric
- Next 3 characters are alphanumeric
- Last 2 characters are alpha
- Second character of numeric section can only be 0, 1, 5 or 6.
- Fourth and fifth characters of numeric section must be in the range 01 to 31
Is UK National Insurance Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of United Kingdom National Insurance Number |
| Properties | Default |
| Pass | SP939393H, PX123456D, SW355667G |
| Fail | 12SP9393H, S3P93930D, 11223344SP00ddSS |
Is UK Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of United Kingdom phone number, also allows +44 national code in addition to extension numbers of 3 or 4 digits |
| Properties | Default |
| Pass | +447222555555, +44 7222 555 555, (0722) 5555555 #2222 |
| Fail | (+447222)555555, +44(7222)555555, (0722) 5555555 #22 |
Is UK Mobile Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | United Kingdom mobile phone number validation with optional +44 national code, also allows optional brackets and spaces at appropriate positions |
| Properties | Default |
| Pass | 07222 555555, (07222) 555555, +44 7222 555 555 |
| Fail | 7222 555555, +44 07222 555555, (+447222) 555555 |
Is US Zip Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates US Zip Code |
| Properties | Default |
| Pass | 48222, 48222-1746 |
| Fail | 4632, Blake, 37333-32 |
Is US State
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates US State 2 letter abbreviations |
| Properties | Default |
| Pass | CO, GA, TX |
| Fail | A, ZZ, Florida |
Is US Social Security Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates US Social security number |
| Properties | Default |
| Pass | 123-45-6789, 123 45 6789, 123456789 |
| Fail | 12345-67-890123, 1234-56-7890, 123-45-78901 |
Is US Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | US Phone Number Validation |
| Properties | Default |
| Pass | 5305551212, (530) 555-1212, 530-555-1212 |
| Fail | 0010011212, 1991991212, 123) not-good |
Is Canadian Zip Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Canadian postal code format verification. The format of a Canadian postal code is LDL DLD where L is alpha characters and D are numeric digits. But there are some exceptions. The letters D, F, I, O, Q and U never appear in a postal code because of their Advanced similarity to 0, E, 1, 0, 0, and V respectively. In addition to avoiding the six “forbidden” letters W and Z also do not appear as the first letter of a postal code (at least not at present). |
| Properties | Default |
| Pass | M1R 4B0, L0R 1B1, L0R1B9 |
| Fail | W1R 4B0, L0R 1D1, LOR1B9 |
Is Canadian Provincial Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Canadian provincial codes |
| Properties | Default |
| Pass | ON, PE, NB |
| Fail | OB, NM |
Is Canadian Branch-Transit/ Bank code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Canadian Branch-Transit number. The branch number must be 3 or 4 digits then '-' then five digits |
| Properties | Default |
| Pass | 654-45654, 5544-65486 |
| Fail | 455645564, 44-55545, 55455-54565 |
Is Canadian Social Insurance Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Canadian Social Insurance Number |
| Properties | Default |
| Pass | 046 454 286, 123-456-789 |
| Fail | 046FF 454 286, 123GG-456-789 |
Is Australian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Australian postal code verification. Australia has 4-digit numeric postal codes with the following state based specific ranges. ACT: 0200-0299 and 2600-2639. NSW: 1000-1999, 2000-2599 and 2640-2914. NT: 0900-0999 and 0800-0899. QLD: 9000-9999 and 4000-4999. SA: 5000-5999. TAS: 7800-7999 and 7000-7499. VIC: 8000-8999 and 3000-3999. WA: 6800-6999 and 6000-6799 |
| Properties | Default |
| Pass | 0200, 7312, 2415 |
| Fail | 0300, 7612, 2915 |
Is Australian Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validation of Australian phone number. Accepts all forms of Australian phone numbers in different formats (area code in brackets, no area code, spaces between 2-3 and 6-7th digits, +61 international dialing code). Also Checks those area codes are valid (if provided). |
| Properties | Default |
| Pass | 0403111111, (03) 1111 1111, +61403111111, 02 9111 1111, 0403 111111, 91111111 |
| Fail | 9111 11111, 99 1111 1111 |
Is Australian Mobile Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Australian Mobile Number |
| Properties | Default |
| Pass | 0412345678 |
| Fail | 0299999999 |
Is Argentinian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Argentinian Post Code |
| Properties | |
| Pass | C1406HHA, A4126AAB, c1406hha |
| Fail | c1406HHA, 4126, C1406hha |
Is Dutch Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Dutch Postal Code |
| Properties | Default |
| Pass | 1234AB, 1234 AB, 1001 AB |
| Fail | 0123AB, 1234A B, 0123 AB |
Is Dutch Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Dutch Phone Number |
| Properties | Default |
| Pass | +31235256677, +31(0)235256677, 023-5256677 |
| Fail | +3123525667788999, 3123525667788, 232-2566778 |
Is Dutch Car Number Plate
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Dutch Car Number Plate |
| Properties | Default |
| Pass | ABC123, 12-AB-AB, 12-ABC-1 |
| Fail | 12ABAB, 12ABC1, 1ABC12 |
Is Belgian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Belgian Post Code |
| Properties | Default |
| Pass | 1234 |
| Fail | 123, 123A |
Is Belgian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Belgian VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | BE123456789, 0123456789 |
| Fail | BE12345678, O123456789 |
Is French Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | French Post Code Validation |
| Properties | Default |
| Pass | 12345, F-12345, F-2B100 |
| Fail | F12345, F-123456, 123456 |
Is French VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | French VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | FRAB 123456789, L7 123456789 |
| Fail | FRAB123456789, L7 L23456789 |
Is French Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | French Phone Number Validation |
| Properties | Default |
| Pass | 01 46 70 89 12, 01-46-70-89-12, 0146708912 |
| Fail | 01-46708912, 01 46708912, +33235256677 |
Is German Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates German Post Code format |
| Properties | Default |
| Pass | 12556, 01550, 80796 |
| Fail | 05234, 8973, 62980 |
Is German VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | German VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | DE123456789, 224466880 |
| Fail | DE12345678, 22446688B |
Is German Car License Plate
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | German Car License Plate Validation |
| Properties | Default |
| Pass | F-RM373, WÜ-Z1, K- 07333, HN-WK11H |
| Fail | MOS-AS |
Is German IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | German International Bank Account Number Validation |
| Properties | Default |
| Pass | DE89 3704 0044 0532 0130 00, DE89370400440532013000 |
| Fail | DE89-3704-0044-0532-0130-00 |
Is Italian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Postcode check for Italy (including possible Vatican/Italy indications) |
| Properties | Default |
| Pass | 1234, V-1234 |
| Fail | 12345 |
Is Italian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Italian VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | IT12345678901, 12345678901 |
| Fail | IT1234567890, 1234567890I |
Is Italian IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Italian International Bank Account Number Validation |
| Properties | Default |
| Pass | IT28 W800 0000 2921 0064 5211 151, IT28W8000000292100645211151 |
| Fail | IT28-W800-0000-2921-0064-5211-151 |
Is Italian Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Italian phone number |
| Properties | Default |
| Pass | 02-343536, 02/343536, 02 343536 |
| Fail | 02a343536, 02+343536 |
Is Italian Mobile Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Italian mobile phone number with (or without) the International code |
| Properties | Default |
| Pass | +393471234567, 3381234567 |
| Fail | +39 3401234567, 347 1234567, 338-1234567 |
Is Spanish Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Spanish Post Code Validation |
| Properties | Default |
| Pass | 12345, 10234, 01234 |
| Fail | 00123 |
Is Spanish VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Spanish VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | ES01234567A, A12345678 |
| Fail | ES012345678, AB2345678 |
Is Spanish IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Spanish IBAN Validation |
| Properties | Default |
| Pass | ES91 2100 0418 4502 0005 1332, ES9121000418450200051332 |
| Fail | ES91-2100-0418-4502-0005-1332 |
Is Spanish Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Spanish Phone Number Validation |
| Properties | Default |
| Pass | 972367087, 97-3770866, 972-377086 |
| Fail | 9988-989898, 989898988989, 9 9898989898 |
Is Swedish Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Swedish Post Code Format |
| Properties | Default |
| Pass | 12345, 932 68, S-621 46 |
| Fail | 5367, 425611, 31 545 |
Is Swedish VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Swedish VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | SE123456789012, 123456789012 |
| Fail | SE12345678901, 123456789O12 |
Is Swedish IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Swedish International Bank Account Number IBAN |
| Properties | Default |
| Pass | SE35 5000 0000 0549 1000 0003, SE3550000000054910000003 |
| Fail | SE35-5000-0000-0549-1000-0003 |
Is Swedish Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Swedish Phone Number |
| Properties | Default |
| Pass | +46 8 123 456 78, 08-123 456 78, 0123-456 78 |
| Fail | +46 08-123 456 78, 08 123 456 78, 0123 456 78 |
Is Swedish Person Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Swedish Person Number |
| Properties | Default |
| Pass | 19740609-7845, 19811116-7845, 20010913-7598 |
| Fail | 21003612-9999, 18790505-4545, 19740641-5559 |
Is Austrian Mobile Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Austrian Mobile Phone Number |
| Properties | Default |
| Pass | 0664-1234567, 06641234567, 0699-11234567 |
| Fail | 06991-1234567, +43650-1234567, 07661234567 |
Is Danish Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Danish Post Code |
| Properties | Default |
| Pass | DK-1234, dk 1234, Dk-1234 |
| Fail | DK 12345 |
Is Danish VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Danish VAT Numbers format with support for optional member state definition. |
| Properties | Default |
| Pass | DK11 22 33 44 |
| Fail | DK11223344 |
Is Danish Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Danish Phone Number |
| Properties | Default |
| Pass | (+45) 35 35 35 35 , +45 35 35 35 35 , 35 35 35 35 , 35353535 |
| Fail | (45)35353535 , 4535353535 |
Is Danish Civil Registration Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Danish civil registration number, which consists of 10 numeric characters and one special character '-'. The format is DDMMYY-XXXX |
| Properties | Default |
| Pass | 010380-2343, 120454-5467, 390178-3434 |
| Fail | 1223876776, 4023100923 |
Is Finnish VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Finnish VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | FI12345678, 22446688 |
| Fail | FI1234567, 224466BB |
Is Greek VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Greek VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | EL123456789, 224466880 |
| Fail | EL12345678, 22446688B |
Is Irish VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Irish VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | IE4*12345Z, 0012345K |
| Fail | IE4-12345Z, 00123456 |
Is Luxembourg VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Luxemburg VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | LU12345678, 22446688 |
| Fail | LU1234567, 224466BB |
Is Portuguese VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Portuguese VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | PT123456789, 224466880 |
| Fail | PT12345678, 22446688B |
Is Estonian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Estonian Post Codes |
| Properties | Default |
| Pass | 00000, 99999 |
| Fail | 00 000 |
Is Estonian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Estonian VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | EE123456789, 224466880 |
| Fail | EE12345678, 22446688B |
Is Latvian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Latvian VAT Number |
| Properties | Default |
| Pass | LV12345678901, 12345678901 |
| Fail | IT1234567890, 1234567890I |
Is Lithuanian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Lithuanian VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | LT123456789, 123456789012 |
| Fail | LX123456789, 123466789O12 |
Is Slovenian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Slovenian VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | SI12345678, 22446688 |
| Fail | SI1234567, 224466BB |
Is Slovakian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Slovakian VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | SK1234567890, 1234567890 |
| Fail | SK1234567890, 1234567890 |
Is Slovakian IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Slovakian International Bank Account Number |
| Properties | Default |
| Pass | SK31 1200 0000 1987 4263 7541, SK3112000000198742637541 |
| Fail | SK31-1200-0000-1987-4263-7541 |
Is Polish VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Polish VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | PL1234567890, 1234567890 |
| Fail | PL123456789, 123456789O |
Is Polish IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Polish International Bank Account Number |
| Properties | Default |
| Pass | PL27 1140 2004 0000 3002 0135 5387, PL27114020040000300201355387 |
| Fail | PL27-1140-2004-0000-3002-0135-5387 |
Is Czech Republic VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Czech Republic VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | CZ12345678, 1234567890 |
| Fail | CZ1234567, 12345678901 |
Is Czech Republic IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Czech International Bank Account Number |
| Properties | Default |
| Pass | CZ65 0800 0000 1920 0014 5399, CZ6508000000192000145399 |
| Fail | CZ65-0800-0000-1920-0014-5399 |
Is Netherlands VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | The Netherlands VAT Numbers format verification with support for optional member state definition. |
| Properties | Default |
| Pass | NL123456789B12 |
| Fail | NL123456789012 |
Is Hungarian VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Hungarian VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | HU12345678, 22446688 |
| Fail | HU1234567, 224466BB |
Is Maltese VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Maltese VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | MT12345678, 22446688 |
| Fail | MT1234567, 224466BB |
Is Algerian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Algerian Post Code Format |
| Properties | Default |
| Pass | 12345, 99999, 00000 |
| Fail | 1, 1234, 999999 |
Is Andorran Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Andorran Post Code format |
| Properties | Default |
| Pass | AB 123, AB123 |
| Fail | 12 abc, 12345 |
Is Andorran IBAN
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Andorran International Bank Account Number |
| Properties | Default |
| Pass | AD12 0001 2030 2003 5910 0100, AD1200012030200359100100 |
| Fail | AD12-0001-2030-2003-5910-0100 |
Is Azerbaijani Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Azerbaijani Post Code format |
| Properties | Default |
| Pass | AZ 1234, AZ1234 |
| Fail | 12 abcd, AB 1234 |
Is Bahraini Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Bahraini Post Code format |
| Properties | Default |
| Pass | 123, 1299, 199 |
| Fail | 1300, 000, 99 |
Is Bangladeshi Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Bangladeshi Post Code format |
| Properties | Default |
| Pass | 1000, 9999, 1234 |
| Fail | 123456, 0123, 99 |
Is Belarusian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Belarusian Post Code format |
| Properties | Default |
| Pass | 123456, 000000, 999999 |
| Fail | 0, 9, 1234 |
Is Brunei Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Brunei Post Code format |
| Properties | Default |
| Pass | BT2328, KA1234 |
| Fail | AB1234, AB 1234 |
Is Chilean Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Chilean Post Code format |
| Properties | Default |
| Pass | 872-0019, 000-0000, 999-9999 |
| Fail | 000 0000, 000000 |
Is Croatian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Croatian Post Code format |
| Properties | Default |
| Pass | HR-00000, HR-99999 |
| Fail | HR 00000, 00000 |
Is Cyprus Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Cyprus Post Code format |
| Properties | Default |
| Pass | 1000, 9999, 0000 |
| Fail | 1, 99999, 99 000 |
Is Cyprus VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Cyprus VAT Numbers format verification with support for optional member state definition |
| Properties | Default |
| Pass | CY12345678A, 12345678A |
| Fail | CY1234567A, 123456789 |
Is Egyptian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Egyptian Post Code format |
| Properties | Default |
| Pass | 00000, 99999 |
| Fail | 0 0 0 00, 00 |
Is Ethiopian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Ethiopian Post Code format |
| Properties | Default |
| Pass | 1000, 9999 |
| Fail | 1 999 |
Is Faroe Islands Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Faroe Islands Post Code format |
| Properties | Default |
| Pass | FO100, FO000, FO 000 |
| Fail | AB 123, AB123 |
Is French Polynesia Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates French Polynesia Post Code format |
| Properties | Default |
| Pass | 00000, 99999 |
| Fail | 00 000, 99 9 9 9 |
Is Guadeloupe Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Guadeloupe Post Code format |
| Properties | Default |
| Pass | 97100, 98099 |
| Fail | 12345, 97 100 |
Is Guinean Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Guinean Post Code format |
| Properties | Default |
| Pass | 001 BP 123, 499 BP 999 |
| Fail | 001BP999, 999 BP 000 |
Is Guinea-Bissau Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Guinea-Bissau Post Code format |
| Properties | Default |
| Pass | 1000, 1999, 9999 |
| Fail | 0000, 0123 |
Is Russian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Russian Post Code |
| Properties | Default |
| Pass | 150016 |
| Fail | wert12 |
Is Russian Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Russian Phone Number |
| Properties | Default |
| Pass | +7(916)9985670, 8-912-268-5440, 8905148-3339, 8(913)448-51-90, 903-345-34-34, 903-34-334-34, 903-34-33434 |
| Fail | +33903-34-33434 |
Is Israeli Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Israeli Phone Number Format |
| Properties | Default |
| Pass | +972-4-8253055, 972-4-8615466, 972-04-8564521 |
| Fail | 04-5487665, 05-455665545, 456884624 |
Is Israeli Mobile Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Israeli Mobile Phone Number |
| Properties | Default |
| Pass | 050-1234567, 0501234567, 501234567 |
| Fail | 0601234567, 5412345678 |
Is Peru Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Peru Phone Number format |
| Properties | Default |
| Pass | 263-8854, 5660578 1235, 622-4588 21 |
| Fail | 1227585, 4224586 50124, 0554499 |
Is Peru Cellular Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Peru Cellular Number format |
| Properties | Default |
| Pass | 8874-2544, 99106800, 84509955 |
| Fail | 6540-9985, 77329390, 725-2763 |
Is Indian Post Code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Indian Post Code |
| Properties | Default |
| Pass | 400 099, 400099, 400050 |
| Fail | 2345678, 12345, asdf |
Is Indian Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Indian Phone Number |
| Properties | Default |
| Pass | 0493 - 3227341, 0493 3227341, 493 3227341 |
| Fail | 93 0227341, 493 322734111, 493 – 3227341 |
Is Indian Mobile Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Indian Mobile Phone Number |
| Properties | Default |
| Pass | +919847444225, +91-98-44111112, 98 44111116 |
| Fail | +919800444225, +947444225, 44111116 |
Is Indian Vehicle Registration Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Indian Vehicle Registration Number |
| Properties | Default |
| Pass | mh 12 bj 1780, mmx 1234 |
| Fail | mmm 123 1234, mm 12 bj 345, mm 12345 |
Is South African Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates South African Phone Number |
| Properties | Default |
| Pass | 0333872119, 033 386162, 074 101 2850 |
| Fail | 033386 2612 |
Is South African Mobile Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | only allows valid cell phones from South African service providers |
| Properties | Default |
| Pass | 0848298477, 084 829 8477, 084-829 8477 |
| Fail | 084829 8477 |
Is South African VAT Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates South African VAT Number |
| Properties | Default |
| Pass | 40123456789 |
| Fail | 50123456789, 123466789O12 |
Is South African Company Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates South Company VAT Number |
| Properties | None |
| Pass | 2001/067995/23, 1989/064445/73 |
| Fail | LX123456789, 123466789O12 |
Is US or CA Zip code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates US or CA Zip code format |
| Properties | Default |
| Pass | 00501, 84118-3423, n3a 3B7 |
| Fail | 501-342, 123324, Q4B 5C5 |
Is Swiss Post code
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Swiss post code format |
| Properties | None |
| Pass | 1000, 1200, 8200, 8048, 9999 |
| Fail | a-z, aaaa, 123, 0000 |
Is Swiss Phone Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Swiss Phone Number format |
| Properties | None |
| Pass | +41 44 123 12 34, +41 (0) 44 123 12 34, +41-44-123-1234, 0041 44123 12 34 |
| Fail | +41 0 44 123 1234, +41.44.123.1234 |
Is Swiss Mobile Number
| Key | Value |
|---|---|
| Category | Validation Function |
| Description | Validates Swiss Mobile Number format |
| Properties | None |
| Pass | |
| Fail |
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum