Functions Reference

Data type returned
text
Description
Returns the first letter of each word in text as uppercase and all other letters as
lowercase.
Examples
Proper(“ABCD”) returns Abcd.
Proper(Name) returns Yumiko Kitagawa, when the Name field contains YUMIKO
KITAGAWA.
Replace
Format
Replace(text;start;numberOfCharacters;replacementText)
Parameters
text - any text expression or text field
start - any numeric expression or field containing a number representing the starting
position in text.
numberOfCharacters - any numeric expression or field containing a number
representing the number of characters to remove from text.
replacementText - any text expression or field containing the text to replace in the
original string.
Data type returned
text
Description
Replaces a string of characters in text with replacementText. Character replacement
in text begins at the start character position and continues for
numberOfCharacters characters. Compare to the Substitute function.
Examples
Replace(“1234567”;5;1;“X”) returns 1234X67.
Replace(“1234567”;5;1;“XX”) returns 1234XX67.
Replace(“1234567”;5;2;“X”) returns 1234X7.