Indicates if a string has numbers or uppercase and lowercase characters.
Category: | String |
Returned data type: | Integer |
PATTERN(string)
string
specifies a string that is to be evaluated for numbers, uppercase characters, and lowercase characters; this can be specified as fixed string, field name, or expression
Note | If string is NULL, the function returns a NULL value. If string is empty (""), an empty value is returned. |
The returned string contains a 9 in place of each number, an “A” for each uppercase character, and an “a” for each lowercase character. Other characters are not replaced.
source_string = "12/b Abc-Str."
result = pattern(source_string) // outputs "99/a Aaa-Aaa."