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
Replace/Append Selection
Type Selection
Popular Predecessors
- String Manipulation7 %
- Number to String6 %
CSV Reader4 %File Reader3 %- String to Date&Time3 %
- Rule-based Row Filter3 %
- Variable to Table Row2 %
- Date&Time Shift2 %
String To Number2 %- Column Filter2 %
- Rule Engine2 %
- String to Date/Time (legacy)2 %
- String to Duration2 %
- Neo4j Reader2 %
- String Manipulation (Multi Column)2 %
- Constant Value Column1 %
- GroupBy1 %
- Cell Splitter1 %
- Sorter1 %
- Java Snippet (simple)1 %
- Create Date&Time Range1 %
- Variable to Table Column1 %
- Concatenate1 %
- Joiner1 %
- Table Creator1 %
- Column Combiner1 %
Number To String1 %Row Filter (deprecated)1 %- Missing Value1 %
Column Rename1 %- String Replacer1 %
- Math Formula1 %
- Date&Time Difference1 %
- Date&Time to String1 %
- Legacy Date&Time to Date&Time1 %
- Extract Duration Fields1 %
Loop End1 %- String to Number1 %
- Column Expressions (legacy)1 %
- Duration to String1 %
- Duration to Number1 %
- CSV Reader1 %
- Excel Reader1 %
- Modify Time1 %
- Table Manipulator1 %
- Date&Time to legacy Date&Time< 1 %
- Cross Joiner< 1 %
- Java Snippet< 1 %
- Column Aggregator< 1 %
Joiner< 1 %- Timer Info< 1 %
Excel Reader (XLS)< 1 %- Time to String (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
Extract Date&Time Fields< 1 %- Date/Time Shift (legacy)< 1 %
Variable to Table Column< 1 %- Cell Splitter By Position< 1 %
- Pivot< 1 %
JSON Reader< 1 %- Column Auto Type Cast< 1 %
- Number Rounder< 1 %
CASE Switch Data (End)< 1 %Table Row to Variable< 1 %- Regression Predictor< 1 %
- Numeric Binner< 1 %
- Date&Time-based Row Filter< 1 %
- URI to String< 1 %
Variable to Table Row< 1 %Database Reader< 1 %Database Looping< 1 %Line Reader< 1 %Table Reader< 1 %Variable Loop End< 1 %- Category to Number< 1 %
- Duplicate Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Column Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Unpivot< 1 %
- Statistics< 1 %
- DB Reader< 1 %
Excel Reader (XLS)< 1 %- R Snippet< 1 %
- Modify Date< 1 %
- XPath< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
- Double to Integer< 1 %
- Number to String (PMML)< 1 %
- DB Insert< 1 %
- Empty Table Creator< 1 %
- Variable Expressions (legacy)< 1 %
- Math Formula (Multi Column)< 1 %
- List Files/Folders< 1 %
- Scatter Plot (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- Date&Time Part Extractor< 1 %
- Window Loop Start< 1 %
- Date Field Extractor (legacy)< 1 %
Views
- This node has no views
Workflows
01_Guided_Analytics_for_ML_AutomationKNIME Hub- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- 01_Guided_Analytics_for_ML_AutomationKNIME Hub
- Show all 42 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.