You are here: Field Rules Reference > Field Rules Summary > TblText

TblText

Use this field level rule to get a text table item based on a key built from the source field name concatenated with the data retrieved from the source record. This rule supports overflow. Keep in mind these considerations, which pertain to the external ASCII text table referenced by this rule.

Keys can be up to 12 characters in length.
The key begins in position 1 in the text file.
The returned text begins in position 14 in the text file.
Only the first occurrence of the match is returned to the caller.

Each data line in the text table file must follow the following format:

KEY;ENTRY

where KEY is a value of up to 12 characters, padded right with spaces. ENTRY is the text data associated with the key entry.


	Note	All support for this rule resides in a single table file. You specify the name of this file in the FSISYS.INI file in the TEXTTBL option in the Data control group.

Open table of contents