Juniper Systems Allegro DOS Manual - Manual (Page 140)

Page 4-74 Windows CE
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”.
Upper(text) Converts text to uppercase.
Example: Upper(“Allegro FPC”) equals ALLEGRO FPC.
Value(text) Converts a text that represents a number to the number.
Example: Value(“1000”) equals 1000.
Information & Lookup Functions
Column(reference) Returns the column number of the given reference.
Columns(range) Returns the number of columns in an array or reference.
Example: Columns(A1:D1) equals 4.
HLookup(lookupValue, data, row) Searches for a value in the top row of a
data table and then returns a value in the same column from a row you
specify. LookupValue is the value to be found in the first row of the data
table. Data is the table of data. Row is the row number in the data table
from which the matching value is returned.
Index(range, rowNum, colNum) Returns a reference to a specified cell
within range.
IsBlank(value) Returns TRUE if the value is blank.