| Function | Short Description |
|---|---|
| CombineText | This function is typically used in diagram text schemes. It
allows you to combine text by adding a prefix and/or suffix to the
text returned by a given data reference; or to optionally supply
alternative text to use if no text is returned.
See also ExistsText, NotExistsText and ForceText. |
| ContainsText | Used for search for text in records, and other data items. |
| ExistsText | This function is typically used in diagram text schemes. It allows you to specify a data reference, and text to be output if, and only, if data is found for the specified data reference. |
| ForceText | This function is typically used in diagram text schemes. It
simply outputs the text specified. It is useful because an
ordinary label is only output if the data reference following it
matches some data. If you want the label to be output regardless,
use ForceText.
See also CombineText, ExistsText and NotExistsText. |
| GetDisplayText | Provides a standard way of displaying information about any data item. |
| GetLabelledText | Only for use with long text fields that can include multiple paragraphs (notes, address fields, etc). Returns all text within a given paragraph, following a specified label. |
| GetParagraph | Only for use with long text fields that can include multiple paragraphs (notes, address fields, etc). Returns a numbered paragraph from the text field. |
| NotExistsText | This function is typically used in diagram text schemes. It
allows you to specify a data reference, and text to be output if,
and only, if data is not found for the specified data reference
See also ExistsText, CombineText and ForceText. |
| Sex |
Used for outputting gender-specific text. |
| Text |
Used for assembling complex text strings. See also See Type-Specifier functions. |
| TextPart | Although designed primarily to help with the presentation of place information in reports and elsewhere, this function can however be used with any text fields. It returns one or more parts of any comma-separated text. |
| TextIf | Takes a boolean expression (True or False) and 2 text strings. If the boolean expression evaluates as True, the first text expression is returned; otherwise the second text expression is returned. |
| ToLower | Converts a string expression to lower case. |
| ToUpper | Converts a string expression to upper case. |