| Visual Dictionary |
|
| Splitting a field | It is quite
common to have a file where a physical field contains
multiple logical fields. To define these types of fields
using the Visual Dictionary take the mouse and position
it over the position in the field that defines the start
of a new field. Press the Right mouse button and select
the Split field option from the menu. This will split the physical field into two unique logical fields. The area in front of the split point will retain the original field name but will have its size adjusted. The area split off will have a new name assigned and a new length calculated and will be set to a String data type. Each physical field can have any number of logical splits. The only restriction is that each split must consist of at least one character. |
| Example | Consider a physical field
consisting of 60 characters where the first 30 being the
address line and the second 30 are the City. To split
this field you would position the mouse over column 31,
press the Right mouse button and select the Split field. This would result in two thirty character fields. |