|
This function
|
Returns
|
|---|
|
|
1 (True) for an exact match, or 0 (False) for a mismatch between two text strings or container fields.
|
|
|
|
Only the specified characters, in the order that they were originally entered in the text.
|
|
|
|
Only the specified values, in the order that they were originally entered in the text.
|
|
|
|
|
|
Dates in the specified text as field type date, for use in formulas involving dates or date functions.
|
|
|
|
Numbers in the specified text as field type number, for use with formulas involving numbers or numeric functions.
|
|
|
|
The specified text, converted to the SVG (Scalable Vector Graphics) format.
|
|
|
|
The specified number, date, time or timestamp as field type text, for use with formulas involving text or text functions.
|
|
|
|
Times or timestamps in the specified text as field type time, for use with formulas involving the time or timestamp functions.
|
|
|
|
The specified data as field type timestamp, for use with formulas involving timestamps.
|
|
|
|
The specified text, converted with URL (Uniform Resource Locators) encoding.
|
|
|
|
A specific value from a list of values.
|
|
|
|
Hiragana converted from Katakana (hankaku and zenkaku).
|
|
|
|
Hankaku Katakana converted from Zenkaku Katakana.
|
|
|
|
Zenkaku Katakana converted from Hankaku Katakana.
|
|
|
|
Kanji numerals converted from Arabic numerals.
|
|
|
|
Zenkaku Katakana converted from Hiragana.
|
|
|
|
The specified number of characters in the text, counting from the left.
|
|
|
|
The specified number of values in the text, counting from the left.
|
|
|
|
The specified number of words in the text, counting from the left.
|
|
|
|
The number of characters in the specified text, including all spaces, numbers, and special characters.
|
|
|
|
All letters in the specified text as lowercase.
|
|
|
|
The specified number of characters in the text, starting at a specified character position.
|
|
|
|
The specified number of values in the text, starting with a specified value.
|
|
|
|
The specified number of words in the text, starting with a specified word.
|
|
|
|
Roman numbers converted from Japanese text.
|
|
|
|
The number of occurrences of a search string in the specified text.
|
|
|
|
The specified occurrence of a search string, starting from a specified position.
|
|
|
|
The first letter of each word in the specified text as uppercase, and all other letters as lowercase.
|
|
|
|
The specified text surrounded by quotation marks (" ").
|
|
|
|
A new string of characters consisting of the specified text as modified by the specified replacement text.
|
|
|
|
The specified number of characters in the text, counting from the right.
|
|
|
|
The specified number of values in the text, counting from the right.
|
|
|
|
The specified number of words in the text, counting from the right.
|
|
|
|
Hankaku (alphanumeric & symbols) converted from Zenkaku (alphanumeric & symbols).
|
|
|
|
Zenkaku (alphanumeric & symbols) converted from Hankaku (alphanumeric & symbols).
|
|
|
|
The combined text and numbers in a specified value, with the numbers incremented by the specified amount.
|
|
|
|
A text string with every occurrence of a specified search string in the text replaced by a specified replacement string.
|
|
|
|
Text stripped of all leading and trailing spaces.
|
|
|
|
Text with full width spaces between non-Roman and Roman characters removed.
|
|
|
|
All letters in the specified text as uppercase.
|
|
|
|
A count of the total number of values in the specified text.
|
|
|
|
A count of the total number of words in the specified text.
|
|
