Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
The HasValue()
function checks whether the input parameter is not empty and has a specific value.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
If the input parameter is a list or a collection (like a Concept-Set), then the HasValue()
function checks if the list has at least 1 row.
The IsEmpty() function checks the opposite of this function.
Returns true
if parameter
is not empty and contains a specific value.
Returns false
if parameter
is empty.
Name | Type | Required | Description |
---|---|---|---|
parameter
any
Field that is checked for a value
The IsKnown()
function checks whether the input parameter is known and recognizable as a value or element.
It is only slightly different from HasValue()
in the way that an empty text-value is a known element (it is a text), but it does not have a value.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
If the input parameter is a list or a collection (like a Concept-Set), then the IsKnown()
function checks if the list has at least 1 row.
The IsUnknown()
function checks the opposite of this function.
Returns true
if parameter
is not unknown.
Returns false
if parameter
is unknown.
The IsEmpty()
function checks whether the input parameter is empty.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
If the input parameter is a list or a collection (like Concept-Set), then the IsEmpty
function checks if the list has 0 rows.
The HasValue() function checks the opposite of this function.
Returns true
if parameter
is empty.
Returns false
if parameter
is not empty.
The IsValidBSN()
function checks whether the input parameter has a valid BSN format (Dutch social security number).
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Note: BSN is used in the Netherlands as identification number.
Returns true
if text
is indeed a valid BSN.
Returns false
if text
is not a valid BSN.
Name | Type | Required | Description |
---|---|---|---|
Name | Type | Required | Description |
---|---|---|---|
IsValidBSN("123456782")
Result: True
IsValidBSN("123456789")
Result: False
Name | Type | Required | Description |
---|---|---|---|
parameter
any
Field that is checked for a value
parameter
any
Field that is checked for a value
text
text
BSN number to be validated.
The IsValidIBAN()
function checks whether the input value is a valid IBAN format.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Note: IBAN is used for International Bank Account Number identification.
Returns true
if text
is indeed a valid IBAN format.
Returns false
if text
is not a valid IBAN format.
The IsValidBTW()
function checks whether the input parameter is a valid VATIN format.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Note: this function only works for VATIN from the Netherlands
Returns true
if text is indeed a valid VATIN.
Returns false
if text is not a valid VATIN.
IsValidIBAN("123456782")
Result: True
IsValidIBAN("123456789")
Result: False
Name | Type | Required | Description |
---|---|---|---|
Name | Type | Required | Description |
---|---|---|---|
text
text
IBAN number that is validated.
text
text
BTW number to be validated.
The IsValidBankAccount()
function checks whether the input parameter is a valid Dutch bank account format.
Note: this function only works for Dutch Bank Accounts and is an old (though still valid) implementation using the old account-number 11-proof checks. Still available for backwards compatibility in existing projects.
The function IsValidIBAN()
can be used for validating IBAN account numbers.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns true
if parameter
is a valid Dutch bank account.
Returns false
if parameter
is not a valid Dutch bank account
The IsUnknown()
function checks whether the input parameter is unknown and not recognizable as a value or element.
If the input parameter is a list or a collection (like a Concept-Set), then the IsUnknown()
function checks if the list has no rows.
Returns true
if parameter
is unknown.
Returns false
if parameter
is not unknown.
Name | Type | Required | Description |
---|---|---|---|
It is only slightly different fromin the way that an empty text-value is a known element (it is a text and not unknown), but it does not have a value.
This function is SQL compatible. For more information about SQL compatibility, see our .
The
function checks the opposite of this function.
Name | Type | Required | Description |
---|
accountnr
text
Field that is checked for a value
ing
Yes/No
True when its an ING bank account False when it is not an ING bank account
parameter | any | Field that is checked for a value |
The IsValidEmailAddress()
function checks whether the input parameter is a valid E-mail address format. The check is done using a validated Regular Expression.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns true
if email_address
is indeed a valid E-mail address format.
Returns false
if email_address
is not a valid E-mail address format.
This function does NOT check if the e-mail address is an existing address, it only checks if the format is correct according to global e-mail address formatting rules.
Name | Type | Required | Description |
---|---|---|---|
This function is NOT SQL compatible. For more information about SQL compatibility, see our .
IsValidUrl("https://wem.io")
Result: True
IsValidUrl("hssp:\vvv.abcd.org/")
Result: False
Name | Type | Required | Description |
---|
email_address
text
the email address that is validated by the function
URL | text | the URL that the function validates. |
The IsValidPhonenumber()
function checks whether the input value has a valid phone number format.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns true
if Phone_number has a valid phone number format
Returns false
if Phone_number has not a valid phone number format.
IsValidPhonenumber("+31 (20) 240-2120#")
Result: True
IsValidUrl("123+456-789")
Result: False
Name | Type | Required | Description |
---|---|---|---|
phone_number
text
the phone number that the function validates.