String to Duration

Converts string cells to duration cells. The string representation of these durations needs to be in either the ISO-8601 representation (see date-based duration format or time-based duration format for details, e.g. 'P2Y3M1D'), the short letter representation (e.g. '2y 3M 1d'; Date-based duration: y: years, M: months, d: days; Time-based duration: H: hours, m: minutes, s: seconds) or the long word representation (e.g. '2 years 3 months 1 day').

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.

Type Selection

Automatically detect type
It will be automatically detected, whether a date-based or a time-based duration shall be parsed. The type will be determined based on the first cell in each column which can be successfully parsed.
Create time-based duration
All included columns will be converted to time-based duration columns (their data type is "Period").
Create date-based duration
All included columns will be converted to date-based duration columns (their data type is "Duration").
Fail on error
If checked, the node will abort the execution and fail on errors. If unchecked, missing values will be generated instead.

Input Ports

Icon
Input table.

Output Ports

Icon
Output table with duration columns.

Views

This node has no views

Workflows

Further 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.