Skip to content

validateRegExp

Implementations

Microsoft Excel: AIDCT.validateRegExp(regExp, s, errorMessage)

Google Sheets: Google Sheets: aidctValidateRegExp(regExp, s, errorMessage)

Validate a string against a regular expression.

This function returns a matrix of values of the same shape and size as the s parameter.

Parameters

NameTypeDescription
regExpStringRegular expression against which to validate a string.
s**StringString to validate.
errorMessageStringCustom error message to use if validation fails. If not provided, an internal error message is used.

Parameters in italics are optional.

** This parameter accepts a single value, an array of values, or a matrix of values.