8.5

Alternate Syntax
@(line number, from column, to column)
The alternate "quick"syntax lets you grab data from a single line from the first data page in the
file. Here is a breakdown of the syntax (all options are mandatory):
l @():Always surrounds a data selection.
l Line Number: The line from which to get the data.
l From Column: the leftmost character position of the data selection.
l To Column: the rightmost character position of the data selection.
Database Data Selections
These selections are used for database-driven data files such as Database and
CSVemulations. The selection refers to a specific field on any given data page.
Syntax
field(record set number, child number, field name, treatment of character case,
treatment of empty trailing cells)
Here is a breakdown of the syntax (all options are mandatory):
l field():Always surrounds database field selections.
l Record Set Number: The data page (or "record") of the data selection.
l Child Number:Line Number in the record (if there are multiple lines returned for one
single record).
l Field Name: The name of the field you want to retrieve.
l Case Option: This can be one of three options:
l KeepCase:Keeps the current uppercase and lowercase letters as they are.
l UpperCase:Converts all letters to their uppercase equivalent.
l LowerCase:Converts all letters to their lowercase equivalent.
l Trim Option:Can either be "Trim"if you want to trim empty spaces before and after the
data selection or "NoTrim"if you want to retain the extra spaces.
Page 21