Page History

...

• Field names are preceded by a colon (:).
  Example Format Pattern =
  Employee :givename :surname with number :EMPNO was not found.
  
  Return Formatted String =
  Employee DARREN BROWN with number A0001 was not found.
  
  when field givename contains the value "DARREN", field surname contains the value "BROWN" and field empno contains the value "A0001"

• Fields used in the Format Pattern must be used elsewhere in the RDML function.
  Fields may be defined in the repository or internally within the function.

• To include a colon (:) in the returned Formatted String, use two colons in the input Format pattern.
  Example Format Pattern=
  Employee no:::empno
  
  Returned Formatted String=
  Employee no:A0001

• To include a character straight after the field, use brackets().
  Example Format Pattern=
  Employee no:::empno()NoSpace
  
  Returned Formatted String=
  Employee no:A0001NoSpace

• Formatting option/s may be applied to a field value and specified in the Format Pattern.
  Multiple options may be applied to a field value.
  Formatting options must immediately follow the field name and be contained within brackets ().
  
  Example Format Pattern=
  Employee :givename(substr,1,1 UPPER). :SURNAME(trim upper)
  
  Returned Formatted String=
  Employee D. BROWN
  
  

• When multiple formatting options are specified for a field value, the options are applied in the following order
  1. edit code
  2. substring
  3. trim trailing (trim)
  4. trim leading (triml)
  5. trim all
  6. lower
  7. upper
  
  

• The Edit code formatting option are applied only to numeric fields.
  If an edit code formatting option is specified for a character field, it will be ignored.

• Edit codes which suppress leading zeroes will remove any resulting leading blanks.

...