Creating a substring

  1. Specify the virtual field ID using the naming conversion, &XXXX. Use option 1='Create'.
  2. 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.
  3. Select virtual field type 9='Substring'.
  4. Specify the field length.
  5. Specify the 'Field', 'Start position' and 'End position' values.
  6. Press Enter.