User Tools

Site Tools


validate

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

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

validate.txt · Last modified: 2023/02/24 15:53 by hayden.law