{"title":"String to Duration","nodeType":"Manipulator","id":"*pDssMDFTGau1fLQV","factoryName":"org.knime.time.node.convert.stringtodurationperiod.StringToDurationPeriodNodeFactory2","factoryId":"org.knime.time.node.convert.stringtodurationperiod.StringToDurationPeriodNodeFactory2","path":["Other Data Types","Time Series","Transform"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Converts string cells to duration cells. The input strings can follow the ISO 8601 format (see <a href=\"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/time/Period.html#parse%28java.lang.CharSequence%29\" rel=\"ugc nofollow noopener noreferrer\">date-based duration format</a> or <a href=\"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/time/Duration.html#parse%28java.lang.CharSequence%29\" rel=\"ugc nofollow noopener noreferrer\">time-based duration format</a> for details, e.g. <tt>P2Y3M1D</tt> ), a short letter format (e.g., <tt>2y 3M 1d or 2H 3m 1s</tt> ), or a long word format (e.g., <tt>2 years 3 months 1 day</tt> ).\n <br />\n Commonly applied when preparing data containing text-based durations for calculation or further processing.</p>\n        ","shortDescription":"Converts a string to a duration.","keywords":["parse","convert","string","duration","period","interval","hour","minute","second","millisecond","year","month","week","day"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Transform","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAYtJREFUOI2FUs1KAlEYPfcqw0BO4WAKYzrjRkUXVoILwYVhu7ZBT2CBs+wBxE26KeoldBkGbbJV0qp14kArxRRykU0IA3nbTObfjAcuF77zne/n3AsARcnrZ5LXzwAwAEX8g604S2AARADEPMy8rXLn8CdwzMQmK3IW43MNigCsVgCADVNQtODXjwmA2nBgANxmF2qVRAg5opTmAHgXuekrmGusGtEXCilGNBphHo/nGTOeWbk95UXRfZFKpU5UVQ30eu+01WpNms2nXrutPYzH43uHnVoU3eVSqXR2fX3jk2WZ1KpVxGIxEo/HNw3D2NN1PUNt9J50On1cKKhbAGAYBvqDPgCA53kc5nIQBKFrWcDpdB7k86c7VrzL5YIkSUG7AtuSJHFTMwhBp9NF/a6OxmMD4XAYHMf9WM5PKc1UKuUhs0Eyuf9iYwEciUTidTQarRTXarUvQRDO7QqAUrqbzWbfBoPBklhR5FtCCF33D0AIUYLBwKUsKxGe57nh8ONT07Sqrn9fMcYmv9REvF0PJieTAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing string columns with duration information."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with strings parsed to durations."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"String columns","description":"The string columns to convert to duration columns.","optional":false},{"name":"Duration type","description":"The type of the duration to parse.\n<ul><li><b>Auto-detected</b> : Detects whether a date-based or time-based duration should be parsed. The type will be determined based on the first cell in each column which can be successfully parsed. Automatically detect whether the input is date-based or time-based.</li><li><b>Date-based</b> : Converts all included columns to date-based duration columns, with data type &#34;Duration (Date-based)&#34;.</li><li><b>Time-based</b> : Converts all included columns to time-based duration columns, with data type &#34;Duration (Time-based)&#34;.</li></ul>","optional":false},{"name":"If extraction fails","description":"Action to take if the extraction fails.\n<ul><li><b>Insert missing</b> : Sets the output cell to missing if the string column cannot be converted to the specified type.</li><li><b>Fail</b> : Fails with an error if the string column cannot be converted to the specified type.</li></ul>","optional":false},{"name":"Output columns","description":"Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.\n<ul><li><b>Replace</b> : Replaces the selected columns by the new columns.</li><li><b>Append with suffix</b> : Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.</li></ul>","optional":false},{"name":"Output column suffix","description":"The suffix to append to the column names of the new columns.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}