Check Entered Characters¶
CELF provides utility functions for checking input characters.
Function name Details UTIL.ISCHARTYPE Return true if string matches the specified type. UTIL.ISDATE Return true if the specified cell value is a date. UTIL.ISMAILADDR Return true if string is an email address. UTIL.ISNUMBER Return true if the specified cell value is a number. Date or Time values are not evaluated as numbers. UTIL.ISPHONENO Return true if a string is a telephone number. UTIL.ISPOSTALCODE Return true if a string is a post code. UTIL.ISTIME Return true if the specified cell value is a Time. UTIL.ISURL Return true if string is a URL of http or https. UTIL.REGEXP Return true if a string matches the specified format(a regular expression).
Here is about utility function to check characters.
Check if a string matches the specified type.¶
UTIL.ISCHARTYPE function is used to check if a string matches a specified type.
Format¶
UTIL.ISCHARTYPE(text, type, ...)
Details¶
Set below number for character type number.
Character type number Character type 1 One-byte upper alphabet 2 One-byte lower alphabet 3 One-byte alphabet 4 One-byte number 5 One-byte katakana 6 One-byte all (except one-byte katakana) 7 One-byte all 11 Two-byte upper alphabet 12 Two-byte lower alphabet 13 Two–byte alphabet 14 Two-byte number 15 Two-byte hiragana 16 Two-byte katanaka 17 Two-byte all
Tip
You can set multiple character type numbers. If you set and they are identified about one of them, true is returned.
Example of use¶
Check if value is date or not.¶
UTIL.ISDATE function is used to check if the value is date or not.
Format¶
UTIL.ISDATE(value)
Example of use¶
Check if a string is mail address.¶
UTIL.ISMAILADDR function is used to check if a string is a mail address.
Format¶
UTIL.ISMAILADDR(text)
Example of use¶
Check if a value is a number.¶
UTIL.ISNUMBER function is used to check if a value is a number.
Format¶
UTIL.ISNUMBER(value)
Check if a string is recognizable as a telephone number.¶
UTIL.ISPHONENO function is used to check if a string is recognizable as a telephone number.
Format¶
UTIL.ISPHONENO(text)
Check if a string is post code.¶
UTIL.ISPOSTALCODE function is used to chaek if a string is post code.
Format¶
UTIL.ISPOSTALCODE(text)
Example of use¶
Check if a value is Time.¶
UTIL.ISTIME function is used to check if a value is Time.
Format¶
UTIL.ISTIME(value)
Example of use¶
Check if a string is URL.¶
UTIL.ISURL function is used to check if a string is URL.
Format¶
UTIL.ISURL(text)
Example of use¶
Check if a string conforms to a specified format.¶
UTIL.REGEXP function is used to check if a string is in a specified format.
Format¶
UTIL.REGEXP(regexp, text)
Example of use¶
See also
Here is an applied example introduced by Check the characters while inputting.