validateAlphanumeric
Implementations
Microsoft Excel: AIDCT.validateAlphanumeric(s, exclusion)
Google Sheets: Google Sheets: aidctValidateAlphanumeric(s, exclusion)
Validate an alphanumeric string.
This function returns a matrix of values of the same shape and size as the s parameter.
Parameters
| Name | Type | Description |
|---|---|---|
| s** | String | String to validate. |
| exclusion | Number | String values to exclude. Valid values are 0 (no exclusions), 1 (strings starting with 0 excluded), and 2 (strings that are all numeric excluded). |
Parameters in italics are optional.
** This parameter accepts a single value, an array of values, or a matrix of values.