User Manual

Windows CE Page 4-127
Text Functions
Char(number) Returns the character specified by a number.
Example: Char(66) equals B.
Code(text) Returns a numeric code for the first character in a text
string.
Example: Code(“ABC”) equals 65.
Exact(text1, text2) Returns TRUE if two text strings are identical (case
sensitive).
Example: Exact(“palm”, “PALM”) equals FALSE.
Find(findText, withinText, start) Finds string (findText) within another
text string (withinText), and returns its starting position.
Example: Find(“A”, “CBA”, 1) equals 3.
Left(text, num_chars) Returns the leftmost characters from a text string.
Example: Left(“Allegro”, 2) equals “Al”.
Len(text) Returns the number of characters in a text string.
Example: Len(“Allegro”) equals 7.
Lower(text) Converts text to lowercase.
Example: Lower(“Allegro FPC”) equals “allegro fpc”.
Mid(text, start, count) Returns a specific number of characters from a text
string, starting at the position start.
Example: Mid(“Allegro”, 3, 2) equals “le”.
Proper(text) Capitalizes the first letter of all words. Converts all the other
letters to lowercase.
Example: Proper(“this CHAPTER”) equals “This Chapter”.
Replace(oldText, start, count, newText) Replaces part of a text string
oldText, based on the number of characters you specify (start, count), with a
newText.
Example: Replace(“Allegro”, 5, 1, “-Size”) equals “Alle-sizero”.
Rept(text, nTimes) Repeats text the given number of times.
Example: Rept(“-”, 5) equals “——”.
Right(text, num_chars) Returns the rightmost characters from a text
string.
Example: Right(“Allegro”, 2) equals “ro”.
Substitute(text, oldText, newText, n) Substitutes newText for oldText in a
text string. N specifies which occurrence of the oldText you want to replace.
Example: Substitute(“1/1/1999”, “1”, “2”, 2) equals “1/2/1999”.
T(value) Returns the text referred to by value.
Example: A1 contains “AAA” then T(A1) equals “AAA”.