Icon

kn_​example_​date_​time_​am_​pm_​format

Deal with (messy) Time formats containing AM/PM distincions
Deal with (messy) Time formats containing AM/PM distincionshttps://forum.knime.com/t/messy-date-time-string-reformatting/13222/8?u=mlauber71 https://forum.knime.com/t/basic-date-time-conversion/26126/5?u=mlauber71 https://forum.knime.com/t/conversion-problems-string-to-datetime-not-suitable-format/34013/2?u=mlauber71by ipazin (https://forum.knime.com/u/ipazin) MessyDateTimeString.xlsxdd/MM/yy hh:mm:ss aMM/dd/yy HH:mm aainterpret hours as 24h ... initiallyadd_hoursShiftto militarytimeHourresult.xlsxcreate tableAM / PMformat2018-12-24T7:05 PMyyyy-MM-dd'T'h:mm ayyyy-MM-dd'T'h:mm''acreate tableAM / PMformat01/01/19 10:08:00 AMcreate tableAM / PMformat 03/02/2020 01:33 AMMM/dd/yyyy''hh:mm''aM/d/yy h:mm ato_Send.xlsxTransaction Apply DateMMM d, yyyyTransaction Start Date/TimeTransaction End Date/TimeMMM d, yyyy h:mm aExcel Reader (XLS)(deprecated) String to Date&Time String to Date/Time(legacy) Rule Engine Date/Time Shift(legacy) Time FieldExtractor (legacy) Excel Sheet Appender(XLS) (deprecated) Table Creator String to Date&Time String to Date&Time Table Creator Table Creator String to Date&Time String to Date&Time Excel Reader String to Date&Time String to Date&Time Deal with (messy) Time formats containing AM/PM distincionshttps://forum.knime.com/t/messy-date-time-string-reformatting/13222/8?u=mlauber71 https://forum.knime.com/t/basic-date-time-conversion/26126/5?u=mlauber71 https://forum.knime.com/t/conversion-problems-string-to-datetime-not-suitable-format/34013/2?u=mlauber71by ipazin (https://forum.knime.com/u/ipazin) MessyDateTimeString.xlsxdd/MM/yy hh:mm:ss aMM/dd/yy HH:mm aainterpret hours as 24h ... initiallyadd_hoursShiftto militarytimeHourresult.xlsxcreate tableAM / PMformat2018-12-24T7:05 PMyyyy-MM-dd'T'h:mm ayyyy-MM-dd'T'h:mm''acreate tableAM / PMformat01/01/19 10:08:00 AMcreate tableAM / PMformat 03/02/2020 01:33 AMMM/dd/yyyy''hh:mm''aM/d/yy h:mm ato_Send.xlsxTransaction Apply DateMMM d, yyyyTransaction Start Date/TimeTransaction End Date/TimeMMM d, yyyy h:mm aExcel Reader (XLS)(deprecated) String to Date&Time String to Date/Time(legacy) Rule Engine Date/Time Shift(legacy) Time FieldExtractor (legacy) Excel Sheet Appender(XLS) (deprecated) Table Creator String to Date&Time String to Date&Time Table Creator Table Creator String to Date&Time String to Date&Time Excel Reader String to Date&Time String to Date&Time

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: m_lauber
Created at: 2019-01-22
On NodePit since: 2020-08-17
Last update: 2024-04-25
Created with KNIME version: v4.3.3
Tags: ampmdatetimeformatus

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

Try NodePit Runner!