Duration to String

Converts duration cells to string cells. The string representation of these durations can be either the ISO-8601, a short (using letters), or a long (using words) representation.

Options

Column Selection

Column Selector
Only the included columns will be converted.

Replace/Append Selection

Append selected columns
The selected columns will be appended to the input table. The suffix of the appended columns can be provided in the text field to the right.
Replace selected columns
The selected columns will be replaced by the new columns.

Format Selection

ISO-8601 representation
The durations will be formatted using the ISO-8601 representation, e.g. 'P2Y3M5D'.
Long representation
The durations will be formatted using words to represent, e.g. '2 years 3 months 5 days'.
Short representation
The durations will be formatted using letters to represent, e.g. '2y 3M 5d' (Date-based duration: y: years, M: months, d: days; Time-based duration: H: hours, m: minutes, s: seconds).

Input Ports

Icon
Input table.

Output Ports

Icon
Output table with string columns.

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.