Validate

Created by Dariusz Szczendzina, Modified on Wed, 12 Jul, 2023 at 11:08 AM by Dariusz Szczendzina

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

Email

Input one or more Email Addresses and identify whether or not they are valid by scoring them TRUE or FALSE. e.g.

Email	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