Juniper Systems Allegro CX Manual - Manual (Page 162)

162 Allegro CX Owner’s Manual
Fixed(number, numDecPlaces, unDelimiter1000)
Rounds a number to the specifi ed number of decimals and returns
the result as text with or without commas.
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 specifi c number of characters from a text string, starting at
the position start.
Example: Mid(“Allegro”, 3, 2) equals “le”.
Proper(text)
Capitalizes the fi rst 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 specifi es which
occurrence of the oldText you want to replace.
Example: Substitute(“1/1/2003”, “1”, “2”, 2) equals “1/2/2003”.