Text Functions

Use text functions to retrieve information about the contents in alphanumeric cells.

Function	Description
ASC	Returns the ANSI value of a character.
CHR	Returns the ANSI character represented by the ANSI value passed using "Value".
CLNTDIR	Returns the path to the current client file.
CLNTNAME	Inserts the name of the current client file.
CURRENCY	Returns the currency symbol specified in the Windows control panel.
DOCLIBPATH	Retrieves the document library file path and inserts it into an alphanumeric cell.
DOCPATH	Inserts the path for the document
IN	Evaluates the position of string value 1 within value 2.
LEFT	Selects a specified number of characters starting from the leftmost character of a character expression.
LENGTH	Returns the length of a character expression.
LOWER	Converts the string to lower case.
LTRIM	Trims any leading spaces from a string of text.
MID	Returns value 2 characters of a string starting at position value 1 of the string.
MKSTR	Converts any format to a string format.
PRGDIR	Returns the path to the program directory.
RIGHT	Selects the right most specified number of characters of a character expression.
SCANSTR	Evaluates the position of one string value within another string value.
SPACE	Returns value spaces.
STR	Returns value 1 as a string right justified to value 2 characters.
SUBSTR	Selects a portion of a string to display.
TITLE	Returns string to normal case.
TOKEN	Returns specific elements of a token separated list contained in a string.
TOKENSUB	Returns a formatted value containing defined elements
TRIM	Trims any trailing spaces from a string of text.
TRIMRTF	Trims RTF formatting from a string.
UPPER	Converts the string to upper case.
XRND	Evaluates the rounding criteria in a referenced document.
XWKS	Allows information from a cell in another CaseView document to appear in a cell in the current document.

Text Functions

Cookie Notice