Icon

beautify_​date&time_​strings

Example workflow that allows to identify different Date&Time formats in a single columnof strings (first component). For each format a pattern can be given, so that the "String toDate&Time" node can properly transform the data (second component). The strings"today" and "now" are case-insensitively transformed to the date, time & zone of theexecution. Row order is maintained.Failures will most likely happen due to wrong formats given in the table editor. Theformating is the same as the "String to Date&Time" Node would expect. In case of anerror, its best to investigate the "apply Date&Time formats" Component at the "String toDate&Time" Node. The different formats can be looked up here: https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.htmlThe example formats used here (copy&paste this into the "Table editor" Node):yyyy-MM-dd HH:mm:ssyyyy-MM-ddyyyy-MM-dd HH:mmyyyy-MM-dd't'HH:mm:ssyyyy-MM-dd't'HH:mm:ss.SSSZM/dd/yyyy H:mmMM/dd/yyyy H:mmMM/dd/yyyy HH:mmM/d/yyyy H:mMM/d/yyyy HH:mm messydate&time formatsmanuallyinput formats Table Creator Table Editor identify Date&Timeformats apply Date&Timeformats Example workflow that allows to identify different Date&Time formats in a single columnof strings (first component). For each format a pattern can be given, so that the "String toDate&Time" node can properly transform the data (second component). The strings"today" and "now" are case-insensitively transformed to the date, time & zone of theexecution. Row order is maintained.Failures will most likely happen due to wrong formats given in the table editor. Theformating is the same as the "String to Date&Time" Node would expect. In case of anerror, its best to investigate the "apply Date&Time formats" Component at the "String toDate&Time" Node. The different formats can be looked up here: https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.htmlThe example formats used here (copy&paste this into the "Table editor" Node):yyyy-MM-dd HH:mm:ssyyyy-MM-ddyyyy-MM-dd HH:mmyyyy-MM-dd't'HH:mm:ssyyyy-MM-dd't'HH:mm:ss.SSSZM/dd/yyyy H:mmMM/dd/yyyy H:mmMM/dd/yyyy HH:mmM/d/yyyy H:mMM/d/yyyy HH:mm messydate&time formatsmanuallyinput formats Table Creator Table Editor identify Date&Timeformats apply Date&Timeformats

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Lukas.Siedentop
Created at: 2021-06-10
On NodePit since: 2022-02-03
Last update: 2024-11-17
Created with KNIME version: v4.3.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!