-
ASC
—
text with full-width katakana and ASCII characters converted to half-width
-
CHAR
—
the CP1252 (Windows-1252) character for the code point x
-
CLEAN
— text with any non-printable characters removed
-
CODE
—
the CP1252 (Windows-1252) code point for the character c
-
CONCATENATE
—
the concatenation of the strings s1, s2,…
-
DOLLAR
— num formatted as currency
-
EXACT
—
TRUE if string1 is exactly equal to string2
-
FIND
—
first position of string1 in string2 following position start
-
FINDB
—
first byte position of string1 in string2 following byte position start
-
FIXED
—
formatted string representation of num
-
JIS
—
text with half-width katakana and ASCII characters converted to full-width
-
LEFT
—
the first num_chars characters of the string s
-
LEFTB
—
the first characters of the string s comprising at most num_bytes bytes
-
LEN
—
the number of characters of the string s
-
LENB
—
the number of bytes in the string s
-
LOWER
—
a lower-case version of the string text
-
MID
—
the substring of the string s starting at position position consisting of length characters
-
MIDB
—
the characters following the first start_pos bytes comprising at most num_bytes bytes
-
NUMBERVALUE
—
numeric value of text
-
PROPER
— text with initial of each word capitalised
-
REPLACE
—
string old with num characters starting at start replaced by new
-
REPLACEB
—
string old with up to num bytes starting at start replaced by new
-
REPT
— num repetitions of string text
-
RIGHT
—
the last num_chars characters of the string s
-
RIGHTB
—
the last characters of the string s comprising at most num_bytes bytes
-
SEARCH
—
the location of the search string within text after position start
-
SEARCHB
—
the location of the search string within text after byte position start
-
SUBSTITUTE
— text with all occurrences of old replaced by new
-
T
— value if and only if value is text, otherwise empty
-
TEXT
— value as a string formatted as format
-
TRIM
— text with only single spaces between words
-
UNICHAR
—
the Unicode character represented by the Unicode code point x
-
UNICODE
—
the Unicode code point for the character c
-
UPPER
—
an upper-case version of the string text
-
VALUE
—
numeric value of text