Set Extract Options

All calculated asset fields defined can be set up so that only part of the string is selected instead of the entire string. They can also be set up, for example, to use the last part rather than the first part of the string. This can be useful for obtaining the last part of a calculated field that is too long.

Various other settings for manipulating the field contents are also available.

To set extract options:

  1. After you have selected the field data type, click Extract. The button is only enabled for those field that are calculated. This option is not available for user-entered fields. The Asset Field Extract Options dialog box is displayed.

  2. In the Extract Characters From group box, specify whether you want to use the last part or the first part of the string. Select one of the following options:

    • Start - Uses the first part of the string. Use the arrows next to the Skip characters box to specify how many characters are to be skipped from the beginning of the string.
    • End - Uses the last part of the string. Use the arrows next to the Skip characters box to specify how many characters are to be skipped from the end of the string.

    For example, ABCDEF123. If you select End and skip 4 characters, the result is ABCDE.

  3. In the Options group box, select the options as follows:

    • Convert to Upper Case- Select this option to convert the alphabetic characters to upper case, if required.
    • Treat Field as a File Name- Select this option to treat the string in the asset field as a file name.

    Some characters are invalid in file names, so any invalid characters can be replaced with the character specified in the Replace Invalid Characters With box. For example, underscore (_) is a valid file name character and can be used to replace invalid characters.

    If you select the Delete Invalid Characters option then any invalid characters are deleted.

  4. If the extracted field is empty or is not found, then a default value for the string can be specified in the Default Value box. For example, if the text string Not Found is entered in this box, then an empty field or a field that has not been found is assigned this default value.

Related Topics Link IconRelated Information