EscapeE

More on defining composite fields

More on defining composite fields

 Previous topic Next topic Expand/collapse all hidden text  

More on defining composite fields

 Previous topic Next topic JavaScript is required for expanding text  

To display the dialog for setting up complex composite fields, click More... on Definitions page of Field dialog: see Defining a composite field.

Click to expand/collapse this hidden textTo set More options
1.Set the 'Condition' for the field to be output; choose from:
oAlways
oIf field found
oIf field changed
2.Specify the column position of the first character to be extracted from the Component field in 'Extract sub-field' Starting column box.
oClick From start to count columns from the left or
oclick From end to count columns from the right.
3.Specify the place at which to stop extracting characters. This may be one of several options:
oYou may specify an Ending column if counting from left.
oSpecify width as a Number of columns.
oSpecify Terminators - any character that may indicate the end of the piece of data, e.g. comma.
oA sub-string may be found within a field: specify the number of the Word.
oA line may be found within a multi-line field: specify the number of the Line.
4.Choose one of the Components from the drop-down list.
5.Click Add then repeat steps 2 to 4 to build up the entire composed field definition.
oInsert arithmetic expressions in Value as necessary directly from the keyboard: see Composite field expressions.
6.When the composed field definition shown in 'Value' box is complete, click Done.
To assign a value

To simply assign a constant known value to a new composite field:

1.Select the field name from the drop-down list of Components.
2.Enter the value that the field is to take in the Value box.
3.Click Assignment.
4.Click Done then OK.

See also Defining field values.