Format Function Guide
Last updated
Was this helpful?
Last updated
Was this helpful?
In the assignment rules process in TDO, you can use format functions to create data or format data in specific outputs. These functions support numbers, strings, and dates. You can also create randomly generated numbers or dates, in a specific format, within a specified range.
When using these functions, you must select ‘Compose Function’ from the drop-down menu in the ‘Operands’ section of the 'Compose Operands' window (accessed during the 'assignment rules' process).
If you fail to select ‘Compose Function’ the output generated will be the format function string and not an assigned value.
The format function contains a marker, a format, and [optional] the data to be processed. These sections are separated by pipes ( | ). The layout is %<marker>|<format>|<data> . For a date format function, %D|YYYYMMdd|09/01/2024 would output 20240901.
In the case of date formats, if the optional data is omitted, the output would be the current date. %D|YYYYMMdd would output the current date in the format specified.
The table below shows the supported format types and the marker(s) associated with those format types.