Creating a substring
- Specify the virtual field ID using the naming conversion, &XXXX. Use option 1='Create'.
- Specify the column heading by either specifying a description or a message ID. If specifying a description, you can defined the column heading per language by pressing the language button. If specifying a message ID, the column heading is automatically displayed in the end user's M3 language.
- Select virtual field type 9='Substring'.
- Specify the field length.
- Specify the 'Field', 'Start position' and 'End position' values.
- Press Enter.