U.M. (Windows)

Summary of functions C-3
Text functions
The parameter text can be a text expression (in quotes) or a field name.
Syntax Definition
Exact (original text, comparison
text)
Exact (original container,
comparison container)
Compares original text and comparison text for exact
match, including case when comparing text. Returns "1"
for a match, "0" for no match.
Compares original container and comparison container
for exact match. Returns "1" for a match, "0" for no
match.
Left (text, number) Returns the specified number of characters in text,
counting from the left
LeftWords (text, number of
words)
Returns the specified number of words in text, counting
from the left
Length (text) Returns number of characters in text
Lower (text) Converts text to lowercase
Middle (text, start, size) Returns characters in text, counting from the position of
start, through the number of characters in size
MiddleWords (text, starting
word, number of words)
Returns the middle words in text, beginning with the
number of the starting word and continuing through the
number of words
PatternCount (text, search string) Returns the number of occurrences of search string in
text
Position (text, search string,
start, occurrence)
Returns the position of the specified occurrence of
search string in text, from start; otherwise returns 0.
Position is case insensitive.
Proper (text) Converts the first letter in each word of text to uppercase
and the remainder to lowercase
Replace (text, start, size,
replacement text)
Replaces characters in text with replacement text, from
the position of start and containing the number of
characters in size
Right (text, number) Returns the specified number of characters in text,
counting from the right
RightWords (text, number of
words)
Returns the specified number of words in text, counting
from the right
Substitute (text, search string,
replace string)
In text, substitutes each occurrence of search string with
replace string. Substitute is case sensitive.
TextToDate (text) Converts text to a date. Type text in the format MM/DD/
YYYY
TextToNum (text) Converts text to a number
TextToTime (text) Converts text to a time. Type text in the format
HH:MM:SS, with or without seconds and AM or PM.