Table of Contents
Validate
Validate allows you to validate Email Addresses, Postcodes, URL's, Telephone Numbers and dates to check they are syntactically correct.
Date Time
Input one or more dates alongside a desired format and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.
| Date Time | Format | Output |
|---|---|---|
| 01-01-2020 | dd-MM-yyyy | TRUE |
| 40-01-2020 | dd-MM-yyyy | FALSE |
| 01-20-2020 | dd-MM-yyyy | FALSE |
Input one or more Email Addresses and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.
| Output | |
|---|---|
| example@example.com | TRUE |
| example@@example.com | FALSE |
| example@example..com | FALSE |
Postcode
Input one or more Postcodes alongside their respective country identifiers and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.
| Postcode | Country Identifier - ISO 2 | Output |
|---|---|---|
| PO13 9FU | GB | TRUE |
| PO.13 9F.U | GB | FALSE |
| P-O-1-3-9-F-U | GB | FALSE |
Telephone
Input one or more Telephone Numbers alongside their respective country identifiers and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.
| Telephone | Country Identifier - ISO 2 | Output |
|---|---|---|
| 07511111111 | GB | TRUE |
| 0751111111 | GB | FALSE |
| 075111111111 | GB | FALSE |
URL Address
Input one or more URL Addresses and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.
| URL Address | Output |
|---|---|
| microsoft.com | TRUE |
| microsoft,,com | FALSE |
| microsoft.,com | FALSE |
NOTE: When entering a Domain in the input field, make sure it does not have a path attached to it e.g. 'microsoft.com' not 'microsoft.com/page'.
Custom Functions
DQ.VALIDATE_EMAIL
The DQ.VALIDATE_EMAIL function validates an email.
Parameters:
email (string), email to be validated
returns (boolean), true if valid
DQ.VALIDATE_POSTCODE
The DQ.VALIDATE_POSTCODE function validates a postcode.
Parameters:
postcode (string), postcode to be validated
country (string), country identifier, preferred format is ISO2, otherwise the service will attempt to derive country from the input
returns (boolean), true if valid
DQ.VALIDATE_URL_ADDRESS
The DQ.VALIDATE_URL_ADDRESS function validates a URL address.
Parameters:
url (string), URL to be validated
returns (boolean), true if valid
DQ.VALIDATE_TELEPHONE
The DQ.VALIDATE_TELEPHONE function validates a telephone number.
Parameters:
telephone (string), telephone to be validated
country (string), country identifier, preferred format is ISO2, otherwise the service will attempt to derive country from the input
returns (boolean), true if valid
DQ.VALIDATE_DATETIME
The DQ.VALIDATE_DATETIME function validates a datetime in a given format.
Parameters:
datetime (string), datetime to be validated
format (string), format of datetime, from list:
- yy-MM-dd
- yyyy-MM-dd
- yy-dd-MM
- yyyy-dd-MM
- yy-MM-dd hh:mm:ss
- yyyy-MM-dd hh:mm:ss
- yy-dd-MM hh:mm:ss
- yyyy-dd-MM hh:mm:ss
- dd-MM-yy
- dd-MM-yyyy
- MM-dd-yy
- MM-dd-yyyy
- dd-MM-yy hh:mm:ss
- dd-MM-yyyy hh:mm:ss
- MM-dd-yy hh:mm:ss
- MM-dd-yyyy hh:mm:ss
- hh:mm
- hh:mm:ss
- hh:mm:ss:fff
- yyyy-MM-dd-Thh:mm:ssZ
- yyyy-MM-dd hh:mm:ss:fff
returns (boolean), true if valid