Data Quality Regex

Data Quality Regex

International Passport – Talend Data Quality Regex

International Passport Name: International Passport Icon: Author: mhallam Resources: Download: International Passport version 3.1 – Direct download International Passport version 4.0 – Direct download Install Instructions: Example: Coming soon… Features: Overview: ? 9 characters made up of a combination of numbers and/or letters. Where less than 9 characters it will be padded out to the…

Date DD MMM – Talend Data Quality Regex

Date DD MMM Name: Date DD MMM Icon: Author: mhallam Resources: Download: Date DD MMM version 3.1 – Direct download Install Instructions: Example: Coming soon… Features: Overview: Expression that matches the number of day and the first three characters of month with or withou space between the two Release Notes: Release version: 3.1.2 – 2009-07-06…

Numeric – Talend Data Quality Regex

Numeric Name: Numeric Icon: Author: scorreia Resources: Download: Numeric version 1.0 – Direct download Install Instructions: Example: Coming soon… Features: Overview: Matches all numbers Release Notes: Release version: 1.0 – 2009-08-12 10:18:01 new version of the “numeric” pattern so that it does not match the empty field. Compatible: 3.1 (obsolete) 3.2 (obsolete) 4.0 (obsolete) Document…

Minutes Seconds – Talend Data Quality Regex

Minutes Seconds Name: Minutes Seconds Icon: Author: mhallam Resources: Download: Minutes Seconds version 1.0 – Direct download Minutes Seconds version 2.1 – Direct download Install Instructions: Example: Coming soon… Features: Overview: validates minutes:seconds format Validates 3:56, 59:59,… Does not validate 60:59 or 59:60. Release Notes: Release version: 1.0 – 2010-07-27 07:57:32 59:59 Release version: 2.1…

Acronyms – Talend Data Quality Regex

Acronyms Name: Acronyms Icon: Author: scorreia Resources: Download: Acronyms version 1.0 – Direct download Install Instructions: Example: Coming soon… Features: Overview: identify text like “T.R.T.” or “A.I.D.S.” will not match “SNCF” or “A.I” Release Notes: Release version: 1.0 – 2011-02-09 17:49:56 initial release Compatible: 4.1 (obsolete) 4.2 (obsolete) 5.0 (obsolete) 5.1 (obsolete) Document get from…

Swedish Personal Nr (Personnummer) – Talend Data Quality Regex

Swedish Personal Nr (Personnummer) Name: Swedish Personal Nr (Personnummer) Icon: Author: mhallam Resources: Download: Swedish Personal Nr (Personnummer) version 3.1 – Direct download Swedish Personal Nr (Personnummer) version 4.0 – Direct download Install Instructions: Example: Coming soon… Features: Overview: Simple regex for the Swedish personal number. It’s in the form: YYMMDD-xxxx where xxxx is an…

Date DD MMM YYYY – Talend Data Quality Regex

Date DD MMM YYYY Name: Date DD MMM YYYY Icon: Author: mhallam Resources: Download: Date DD MMM YYYY version 3.1 – Direct download Install Instructions: Example: Coming soon… Features: Overview: This regular expressions matches dates of the form dd/MMM/yyyy or dd-MMM-yyyy where dd can be 1 or 2 digits long, MMM is a month abbreviation,…

Properties keys – Talend Data Quality Regex

Properties keys Name: Properties keys Icon: Author: scorreia Resources: Download: Properties keys version 1.0 – Direct download Properties keys version 1.1 – Direct download Install Instructions: Example: Coming soon… Features: Overview: Matches keys of java properties files. Release Notes: Release version: 1.0 – 2009-02-25 11:16:50 initial release Release version: 1.1 – 2009-02-25 13:35:30 previous version…

phone number – Talend Data Quality Regex

phone number Name: phone number Icon: Author: mhallam Resources: Download: phone number version 3.1 – Direct download Install Instructions: Example: Coming soon… Features: Overview: Very flexible phone number entry. — There are many valid ways to enter a phone number, and often there is other data that a restrictive Regex pattern will not abide. —…

Correctly Encoded Characters – Talend Data Quality Regex

Correctly Encoded Characters Name: Correctly Encoded Characters Icon: Author: scorreia Resources: Download: Correctly Encoded Characters version 1.0 – Direct download Install Instructions: Example: Coming soon… Features: Overview: Finds out any badly encoded character Release Notes: Release version: 1.0 – 2013-01-30 20:42:32 initial release Compatible: 5.2 (obsolete) 5.3 (obsolete) 5.4 (obsolete) 5.5 (obsolete) 5.6 (obsolete) 6.0…