Regular Expression Transformation Functions

To change Transformation function properties double click on it

KeyValue
CategoryTransformation Function
DescriptionValidates data against regular expression
Properties

KeyValue
CategoryTransformation Function
DescriptionSplits string using regular expression
Properties

KeyValue
CategoryTransformation Function
DescriptionReplaces string using regular expression (Search For)
Properties

KeyValue
CategoryTransformation Function
DescriptionValidates IP addresses in the dotted quad form
PropertiesDefault
Pass192.168.1.1, 10.2.234.1, 66.129.71.122
Fail192.168.1, 10.2.1234.1, 66 129 71 122

KeyValue
CategoryTransformation Function
DescriptionValidates all IPv6 text representations as defined within RFC 2373
PropertiesDefault
Pass::0:0:0:FFFF:129.144.52.38, FEDC:BA98::3210:FEDC:BA98:7654:3210, ::13.1.68.3
FailFEDC:BA98:7654:3210:FEDC:BA98:7654:3210:1234,3210:FEDC:BA98:7654:3210:1234, :FEDC:BA98:7654:3210:

KeyValue
CategoryTransformation Function
DescriptionEmail 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.
PropertiesDefault
Passjohn@doe.com, john-doe@255.255.255.255, john.doe@john.doe.com
Failjohn@doe, john-doe@999.999.999.999, @john.doe.com

KeyValue
CategoryTransformation Function
DescriptionValidation of 10 digits ISBN. The ISBN number must be preceded by the text “ISBN:” or “ISBN-10:”, the colon is optional.
PropertiesDefault
PassISBN-10: 0-93028-923-4
FailISBN-13: 978-0-5960-0289-3

KeyValue
CategoryTransformation Function
DescriptionValidation of new 13 digits ISBN. The ISBN number must be preceded by the text “ISBN:” or “ISBN-13:”, the colon is optional.
PropertiesDefault
PassISBN-13: 978-0-5960-0289-3
FailISBN-10: 0596002890

KeyValue
CategoryTransformation Function
DescriptionValidation of all major credit cards formats
PropertiesDefault
Pass341-1111-1111-1111, 5431-1111-1111-1111, 30569309025904
Fail30-5693-0902-5904, 5631-1111-1111-1111, 31169309025904

KeyValue
CategoryTransformation Function
DescriptionValidation of URL
PropertiesDefault
Passhttps://www.download.com
Failhttps://999.999.999.999/dfd

KeyValue
CategoryTransformation Function
DescriptionValidation of UNC
PropertiesDefault
Pass\\\\server\c$
Failserver

KeyValue
CategoryTransformation Function
DescriptionValidation of file name format, file name must have a drive letter and an extension
PropertiesDefault
Passc:\1.txt
Failftc

If UK Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates United Kingdom Post Code
PropertiesDefault
PassSW1W 8EU
FailSW1WK8EU

KeyValue
CategoryTransformation Function
DescriptionUnited Kingdom VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassGB123123412, GBGD123, 123123412123
FailGB1231234124, GBGD1234, 023 1234 12 123

KeyValue
CategoryTransformation Function
DescriptionValidation of United Kingdom Bank Sort code
PropertiesDefault
Pass09-01-29, 05-06-25
Fail90125

KeyValue
CategoryTransformation Function
DescriptionValidation of United Kingdom Vehicle registration Number
PropertiesDefault
PassABC 123 A, A 123 ABC, AB 12 ABC
FailAB 123 C, A 123 AB, AB 12 AB

KeyValue
CategoryTransformation Function
DescriptionValidates the United Kingdom Drivers License format as described by the DVLA
PropertiesDefault
PassJOHNS711215GG9SY
FailJOHNS731215GG9SY

https://www.govtalk.gov.uk/gdsc/html/frames/default.htm.

Matches:

  1. Must be 16 characters
  2. First 5 characters are alphanumeric.
  3. Next 6 characters must be numeric
  4. Next 3 characters are alphanumeric
  5. Last 2 characters are alpha
  6. Second character of numeric section can only be 0, 1, 5 or 6.
  7. Fourth and fifth characters of numeric section must be in the range 01 to 31

KeyValue
CategoryTransformation Function
DescriptionValidation of United Kingdom National Insurance Number
PropertiesDefault
PassSP939393H, PX123456D, SW355667G
Fail12SP9393H, S3P93930D, 11223344SP00ddSS

KeyValue
CategoryTransformation Function
DescriptionValidation of United Kingdom phone number, also allows +44 national code in addition to extension numbers of 3 or 4 digits
PropertiesDefault
Pass +447222555555, +44 7222 555 555, (0722) 5555555 #2222
Fail(+447222)555555, +44(7222)555555, (0722) 5555555 #22

KeyValue
CategoryTransformation Function
DescriptionUnited Kingdom mobile phone number validation with optional +44 national code, also allows optional brackets and spaces at appropriate positions
PropertiesDefault
Pass 07222 555555, (07222) 555555, +44 7222 555 555
Fail 7222 555555, +44 07222 555555, (+447222) 555555

KeyValue
CategoryTransformation Function
DescriptionValidates US Zip Code
PropertiesDefault
Pass48222, 48222-1746
Fail4632, Blake, 37333-32

KeyValue
CategoryTransformation Function
DescriptionValidates US State 2 letter abbreviations
PropertiesDefault
PassCO, GA, TX
FailA, ZZ, Florida

KeyValue
CategoryTransformation Function
DescriptionValidates US Social security number
PropertiesDefault
Pass123-45-6789, 123 45 6789, 123456789
Fail12345-67-890123, 1234-56-7890, 123-45-78901

KeyValue
CategoryTransformation Function
DescriptionUS Phone Number Validation
PropertiesDefault
Pass 5305551212, (530) 555-1212, 530-555-1212
Fail0010011212, 1991991212, 123) not-good

KeyValue
CategoryTransformation Function
DescriptionCanadian 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).
PropertiesDefault
PassM1R 4B0, L0R 1B1, L0R1B9
FailW1R 4B0, L0R 1D1, LOR1B9

KeyValue
CategoryTransformation Function
DescriptionValidates Canadian provincial codes
PropertiesDefault
PassON, PE, NB
FailOB, NM

KeyValue
CategoryTransformation Function
DescriptionValidates Canadian Branch-Transit number. The branch number must be 3 or 4 digits then '-' then five digits
PropertiesDefault
Pass654-45654, 5544-65486
Fail455645564, 44-55545, 55455-54565

KeyValue
CategoryTransformation Function
DescriptionValidates Canadian Social Insurance Number
PropertiesDefault
Pass046 454 286, 123-456-789
Fail046FF 454 286, 123GG-456-789

If Australian Post Code

KeyValue
CategoryTransformation Function
DescriptionAustralian 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
PropertiesDefault
Pass0200, 7312, 2415
Fail0300, 7612, 2915

KeyValue
CategoryTransformation Function
DescriptionValidation 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).
PropertiesDefault
Pass0403111111, (03) 1111 1111, +61403111111, 02 9111 1111, 0403 111111, 91111111
Fail9111 11111, 99 1111 1111

KeyValue
CategoryTransformation Function
DescriptionValidates Australian Mobile Number
PropertiesDefault
Pass0412345678
Fail0299999999

If Argentinian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Argentinian Post Code
Properties
PassC1406HHA, A4126AAB, c1406hha
Failc1406HHA, 4126, C1406hha

If Dutch Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Dutch Postal Code
PropertiesDefault
Pass1234AB, 1234 AB, 1001 AB
Fail0123AB, 1234A B, 0123 AB

KeyValue
CategoryTransformation Function
DescriptionValidates Dutch Phone Number
PropertiesDefault
Pass+31235256677, +31(0)235256677, 023-5256677
Fail+3123525667788999, 3123525667788, 232-2566778

KeyValue
CategoryTransformation Function
DescriptionValidates Dutch Car Number Plate
PropertiesDefault
PassABC123, 12-AB-AB, 12-ABC-1
Fail12ABAB, 12ABC1, 1ABC12

If Belgian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Belgian Post Code
PropertiesDefault
Pass1234
Fail123, 123A

KeyValue
CategoryTransformation Function
DescriptionBelgian VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassBE123456789, 0123456789
FailBE12345678, O123456789

If French Post Code

KeyValue
CategoryTransformation Function
DescriptionFrench Post Code Validation
PropertiesDefault
Pass12345, F-12345, F-2B100
FailF12345, F-123456, 123456

KeyValue
CategoryTransformation Function
DescriptionFrench VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassFRAB 123456789, L7 123456789
FailFRAB123456789, L7 L23456789

KeyValue
CategoryTransformation Function
DescriptionFrench Phone Number Validation
PropertiesDefault
Pass01 46 70 89 12, 01-46-70-89-12, 0146708912
Fail01-46708912, 01 46708912, +33235256677

If German Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates German Post Code format
PropertiesDefault
Pass12556, 01550, 80796
Fail05234, 8973, 62980

KeyValue
CategoryTransformation Function
DescriptionGerman VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassDE123456789, 224466880
FailDE12345678, 22446688B

KeyValue
CategoryTransformation Function
DescriptionGerman Car License Plate Validation
PropertiesDefault
PassF-RM373, WÜ-Z1, K- 07333, HN-WK11H
FailMOS-AS

KeyValue
CategoryTransformation Function
DescriptionGerman International Bank Account Number Validation
PropertiesDefault
PassDE89 3704 0044 0532 0130 00, DE89370400440532013000
FailDE89-3704-0044-0532-0130-00

If Italian Post Code

KeyValue
CategoryTransformation Function
DescriptionPostcode check for Italy (including possible Vatican/Italy indications)
PropertiesDefault
Pass1234, V-1234
Fail12345

KeyValue
CategoryTransformation Function
DescriptionItalian VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassIT12345678901, 12345678901
FailIT1234567890, 1234567890I

KeyValue
CategoryTransformation Function
DescriptionItalian International Bank Account Number Validation
PropertiesDefault
PassIT28 W800 0000 2921 0064 5211 151, IT28W8000000292100645211151
FailIT28-W800-0000-2921-0064-5211-151

KeyValue
CategoryTransformation Function
DescriptionValidates Italian phone number
PropertiesDefault
Pass02-343536, 02/343536, 02 343536
Fail02a343536, 02+343536

KeyValue
CategoryTransformation Function
DescriptionValidates Italian mobile phone number with (or without) the International code
PropertiesDefault
Pass+393471234567, 3381234567
Fail+39 3401234567, 347 1234567, 338-1234567

If Spanish Post Code

KeyValue
CategoryTransformation Function
DescriptionSpanish Post Code Validation
PropertiesDefault
Pass12345, 10234, 01234
Fail00123

KeyValue
CategoryTransformation Function
DescriptionSpanish VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassES01234567A, A12345678
FailES012345678, AB2345678

KeyValue
CategoryTransformation Function
DescriptionSpanish IBAN Validation
PropertiesDefault
PassES91 2100 0418 4502 0005 1332, ES9121000418450200051332
FailES91-2100-0418-4502-0005-1332

KeyValue
CategoryTransformation Function
DescriptionSpanish Phone Number Validation
PropertiesDefault
Pass972367087, 97-3770866, 972-377086
Fail9988-989898, 989898988989, 9 9898989898

If Swedish Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Swedish Post Code Format
PropertiesDefault
Pass12345, 932 68, S-621 46
Fail5367, 425611, 31 545

KeyValue
CategoryTransformation Function
DescriptionSwedish VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassSE123456789012, 123456789012
FailSE12345678901, 123456789O12

KeyValue
CategoryTransformation Function
DescriptionSwedish International Bank Account Number IBAN
PropertiesDefault
PassSE35 5000 0000 0549 1000 0003, SE3550000000054910000003
FailSE35-5000-0000-0549-1000-0003

KeyValue
CategoryTransformation Function
DescriptionValidates Swedish Phone Number
PropertiesDefault
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

KeyValue
CategoryTransformation Function
DescriptionValidates Swedish Person Number
PropertiesDefault
Pass19740609-7845, 19811116-7845, 20010913-7598
Fail21003612-9999, 18790505-4545, 19740641-5559

KeyValue
CategoryTransformation Function
DescriptionValidates Austrian Mobile Phone Number
PropertiesDefault
Pass0664-1234567, 06641234567, 0699-11234567
Fail06991-1234567, +43650-1234567, 07661234567

If Danish Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Danish Post Code
PropertiesDefault
PassDK-1234, dk 1234, Dk-1234
FailDK 12345

KeyValue
CategoryTransformation Function
DescriptionValidates Danish VAT Numbers format with support for optional member state definition.
PropertiesDefault
PassDK11 22 33 44
FailDK11223344

KeyValue
CategoryTransformation Function
DescriptionValidates Danish Phone Number
PropertiesDefault
Pass(+45) 35 35 35 35 , +45 35 35 35 35 , 35 35 35 35 , 35353535
Fail(45)35353535 , 4535353535

KeyValue
CategoryTransformation Function
DescriptionValidates Danish civil registration number, which consists of 10 numeric characters and one special character '-'. The format is DDMMYY-XXXX
PropertiesDefault
Pass010380-2343, 120454-5467, 390178-3434
Fail1223876776, 4023100923

KeyValue
CategoryTransformation Function
DescriptionFinnish VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassFI12345678, 22446688
FailFI1234567, 224466BB

KeyValue
CategoryTransformation Function
DescriptionGreek VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassEL123456789, 224466880
FailEL12345678, 22446688B

KeyValue
CategoryTransformation Function
DescriptionIrish VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassIE4*12345Z, 0012345K
FailIE4-12345Z, 00123456

KeyValue
CategoryTransformation Function
DescriptionLuxemburg VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassLU12345678, 22446688
FailLU1234567, 224466BB

KeyValue
CategoryTransformation Function
DescriptionPortuguese VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassPT123456789, 224466880
FailPT12345678, 22446688B

If Estonian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Estonian Post Codes
PropertiesDefault
Pass00000, 99999
Fail00 000

KeyValue
CategoryTransformation Function
DescriptionEstonian VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassEE123456789, 224466880
FailEE12345678, 22446688B

KeyValue
CategoryTransformation Function
DescriptionValidates Latvian VAT Number
PropertiesDefault
PassLV12345678901, 12345678901
FailIT1234567890, 1234567890I

KeyValue
CategoryTransformation Function
DescriptionLithuanian VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassLT123456789, 123456789012
FailLX123456789, 123466789O12

KeyValue
CategoryTransformation Function
DescriptionSlovenian VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassSI12345678, 22446688
FailSI1234567, 224466BB

KeyValue
CategoryTransformation Function
DescriptionSlovakian VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassSK1234567890, 1234567890
FailSK1234567890, 1234567890

KeyValue
CategoryTransformation Function
DescriptionValidates Slovakian International Bank Account Number
PropertiesDefault
PassSK31 1200 0000 1987 4263 7541, SK3112000000198742637541
FailSK31-1200-0000-1987-4263-7541

KeyValue
CategoryTransformation Function
DescriptionPolish VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassPL1234567890, 1234567890
FailPL123456789, 123456789O

KeyValue
CategoryTransformation Function
DescriptionValidates Polish International Bank Account Number
PropertiesDefault
PassPL27 1140 2004 0000 3002 0135 5387, PL27114020040000300201355387
FailPL27-1140-2004-0000-3002-0135-5387

KeyValue
CategoryTransformation Function
DescriptionCzech Republic VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassCZ12345678, 1234567890
FailCZ1234567, 12345678901

KeyValue
CategoryTransformation Function
DescriptionValidates Czech International Bank Account Number
PropertiesDefault
PassCZ65 0800 0000 1920 0014 5399, CZ6508000000192000145399
FailCZ65-0800-0000-1920-0014-5399

KeyValue
CategoryTransformation Function
DescriptionThe Netherlands VAT Numbers format verification with support for optional member state definition.
PropertiesDefault
PassNL123456789B12
FailNL123456789012

KeyValue
CategoryTransformation Function
DescriptionHungarian VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassHU12345678, 22446688
FailHU1234567, 224466BB

KeyValue
CategoryTransformation Function
DescriptionMaltese VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassMT12345678, 22446688
FailMT1234567, 224466BB

If Algerian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Algerian Post Code Format
PropertiesDefault
Pass12345, 99999, 00000
Fail1, 1234, 999999

If Andorran Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Andorran Post Code format
PropertiesDefault
PassAB 123, AB123
Fail12 abc, 12345

KeyValue
CategoryTransformation Function
DescriptionValidates Andorran International Bank Account Number
PropertiesDefault
PassAD12 0001 2030 2003 5910 0100, AD1200012030200359100100
FailAD12-0001-2030-2003-5910-0100

If Azerbaijani Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Azerbaijani Post Code format
PropertiesDefault
PassAZ 1234, AZ1234
Fail12 abcd, AB 1234

If Bahraini Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Bahraini Post Code format
PropertiesDefault
Pass123, 1299, 199
Fail1300, 000, 99

If Bangladeshi Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Bangladeshi Post Code format
PropertiesDefault
Pass1000, 9999, 1234
Fail123456, 0123, 99

If Belarusian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Belarusian Post Code format
PropertiesDefault
Pass123456, 000000, 999999
Fail0, 9, 1234

If Brunei Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Brunei Post Code format
PropertiesDefault
PassBT2328, KA1234
FailAB1234, AB 1234

If Chilean Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Chilean Post Code format
PropertiesDefault
Pass872-0019, 000-0000, 999-9999
Fail000 0000, 000000

If Croatian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Croatian Post Code format
PropertiesDefault
PassHR-00000, HR-99999
FailHR 00000, 00000

If Cyprus Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Cyprus Post Code format
PropertiesDefault
Pass1000, 9999, 0000
Fail1, 99999, 99 000

KeyValue
CategoryTransformation Function
DescriptionCyprus VAT Numbers format verification with support for optional member state definition
PropertiesDefault
PassCY12345678A, 12345678A
FailCY1234567A, 123456789

If Egyptian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Egyptian Post Code format
PropertiesDefault
Pass00000, 99999
Fail0 0 0 00, 00

If Ethiopian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Ethiopian Post Code format
PropertiesDefault
Pass1000, 9999
Fail1 999

If Faroe Islands Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Faroe Islands Post Code format
PropertiesDefault
PassFO100, FO000, FO 000
FailAB 123, AB123

If French Polynesia Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates French Polynesia Post Code format
PropertiesDefault
Pass00000, 99999
Fail00 000, 99 9 9 9

If Guadeloupe Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Guadeloupe Post Code format
PropertiesDefault
Pass97100, 98099
Fail12345, 97 100

If Guinean Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Guinean Post Code format
PropertiesDefault
Pass001 BP 123, 499 BP 999
Fail001BP999, 999 BP 000

If Guinea-Bissau Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Guinea-Bissau Post Code format
PropertiesDefault
Pass1000, 1999, 9999
Fail0000, 0123

If Russian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Russian Post Code
PropertiesDefault
Pass150016
Failwert12

KeyValue
CategoryTransformation Function
DescriptionValidates Russian Phone Number
PropertiesDefault
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

KeyValue
CategoryTransformation Function
DescriptionValidates Israeli Phone Number Format
PropertiesDefault
Pass+972-4-8253055, 972-4-8615466, 972-04-8564521
Fail04-5487665, 05-455665545, 456884624

KeyValue
CategoryTransformation Function
DescriptionValidates Israeli Mobile Phone Number
PropertiesDefault
Pass050-1234567, 0501234567, 501234567
Fail0601234567, 5412345678

KeyValue
CategoryTransformation Function
DescriptionValidates Peru Phone Number format
PropertiesDefault
Pass263-8854, 5660578 1235, 622-4588 21
Fail1227585, 4224586 50124, 0554499

KeyValue
CategoryTransformation Function
DescriptionValidates Peru Cellular Number format
PropertiesDefault
Pass8874-2544, 99106800, 84509955
Fail6540-9985, 77329390, 725-2763

If Indian Post Code

KeyValue
CategoryTransformation Function
DescriptionValidates Indian Post Code
PropertiesDefault
Pass400 099, 400099, 400050
Fail2345678, 12345, asdf

KeyValue
CategoryTransformation Function
DescriptionValidates Indian Phone Number
PropertiesDefault
Pass0493 - 3227341, 0493 3227341, 493 3227341
Fail93 0227341, 493 322734111, 493 – 3227341

KeyValue
CategoryTransformation Function
DescriptionValidates Indian Mobile Phone Number
PropertiesDefault
Pass+919847444225, +91-98-44111112, 98 44111116
Fail+919800444225, +947444225, 44111116

KeyValue
CategoryTransformation Function
DescriptionValidates Indian Vehicle Registration Number
PropertiesDefault
Passmh 12 bj 1780, mmx 1234
Failmmm 123 1234, mm 12 bj 345, mm 12345

KeyValue
CategoryTransformation Function
DescriptionValidates South African Phone Number
PropertiesDefault
Pass0333872119, 033 386162, 074 101 2850
Fail033386 2612

KeyValue
CategoryTransformation Function
Descriptiononly allows valid cell phones from South African service providers
PropertiesDefault
Pass0848298477, 084 829 8477, 084-829 8477
Fail084829 8477

KeyValue
CategoryTransformation Function
DescriptionValidates South African VAT Number
PropertiesDefault
Pass40123456789
Fail 50123456789, 123466789O12

KeyValue
CategoryTransformation Function
DescriptionValidates South Company VAT Number
PropertiesNone
Pass2001/067995/23, 1989/064445/73
FailLX123456789, 123466789O12

KeyValue
CategoryTransformation Function
DescriptionValidates US or CA Zip code format
PropertiesDefault
Pass00501, 84118-3423, n3a 3B7
Fail501-342, 123324, Q4B 5C5

If Swiss Post code

KeyValue
CategoryTransformation Function
DescriptionValidates Swiss post code format
PropertiesNone
Pass1000, 1200, 8200, 8048, 9999
Faila-z, aaaa, 123, 0000

KeyValue
CategoryTransformation Function
DescriptionValidates Swiss Phone Number format
PropertiesNone
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

KeyValue
CategoryTransformation Function
DescriptionValidates Swiss Mobile Number format
PropertiesNone
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

  • aetl/transformation_functions/regular_expressions.txt
  • Last modified: 18/06/2015 11:02
  • by admin