Field Format Editor

Tools > Field Format Editor

Use the field format editor to generate format codes that you can add manually to a setting when editing settings manually using a text editor, for example.

Once the desired format has been specified, it can be copied from the Field format code field by clicking Copy to clipboard, or by selecting the code and pressing Ctrl+C. The format can then be pasted where needed

Define the field format code with the following options:

  • Fill character – The selected character is used to fill an empty character position in the value.

  • Width – The number of character positions. This affects the width of field. Note that for an empty character position, the Fill character option is used.

  • Alignment – Left, right, or none. This is applicable only if the value in the Width field is set larger than zero.

  • Decimals (real) – The number of rounding decimals. This is applicable only if the value is a number.

  • Conversion – Conversion of the value.

  • Print zero – If the resulting value is 0 and you select Yes, the zero value is shown. If you select No, the zero value is not shown.

  • Trim zero – If the resulting value is a decimal value with trailing zeros (for example, 27.3900) and you select Yes, the zeros are removed (for example, 27.39). If you select No, the zeros are shown.

The code is shown in the Field format code field.

See also Editing field formats in the Managing Production Information Administrator's Guide.