Date Extractor

Go to Product

This node extracts all dates and times from text and documents.

Options

Input

Column in the input table with the text to extract.

Drop input column

Enable to remove the input column from the output table.

Output column name

The name/prefix of the appended output column(s).

Mapping

Specify how extracted dates should be mapped to column values; the following mapping types are available:

Rows: Create one new row with a date and time cell for each found date per input.
Collection Cell: Create a single row per input with a collection cell which contains all found dates.
Date and Time Cell (first): Create a single row with a date and time cell for each input row (or a missing value in case no date was found)

Append a column with the parse pattern

When activated, an additional column is added to the output table, which denotes the pattern which was used for parsing the date, e.g. YYYY-MM-DDTHH:MM:SS+HH:MM. (in case “Collection Cell” is selected, this is a Collection Cell as well)

Append a column with the input Row ID

When activated, an additional column with the Row ID of the input column is appended.

Input Ports

: Input text as string.

Output Ports

: Table with extracted dates following the “Mapping” as specified in the configuration.

Popular Predecessors

Column Filter7 %
Rule-based Row Filter4 %
Joiner3 %
Table Creator3 %
File Reader3 %
Show all 71 recommendations

Popular Successors

Date&Time to String5 %
Date&Time to legacy Date&Time4 %
Joiner3 %
Loop End3 %
Column Rename3 %
Modify Date3 %
String To Number3 %
Table Manipulator3 %
String to Date&Time3 %
Extract Duration Fields3 %
Concatenate2 %
Date&Time Difference2 %
Legacy Date&Time to Date&Time2 %
Date&Time-based Row Filter2 %
Modify Time2 %
HTTP Retriever2 %
Catch Errors (Data Ports)2 %
Variable to Table Column2 %
Loop End2 %
Column Filter2 %
Row Splitter2 %
Row Filter2 %
GroupBy2 %
Sorter2 %
String Manipulation2 %
Column Expressions2 %
Math Formula2 %
Excel Writer2 %
Extract Date&Time Fields2 %
Extract Date&Time Fields2 %
Date&Time Shift2 %
Modify Time Zone2 %
Date Field Extractor (legacy)2 %
XPath2 %
Date Extractor2 %
Regex Extractor2 %
Table Row to Variable1 %
CSV Writer1 %
Table Writer1 %
Cell Splitter1 %
Cell Splitter By Position< 1 %
Column Resorter< 1 %
Cross Joiner< 1 %
Joiner< 1 %
Rule Engine< 1 %
~~Regex Extractor~~< 1 %
Table Column to Variable< 1 %
Table Column to Variable< 1 %
Group Loop Start< 1 %
Binner (Dictionary)< 1 %
Column Combiner< 1 %
Number To String< 1 %
Insert Column Header< 1 %
Column Rename (Regex)< 1 %
Nominal Value Row Filter< 1 %
Pivoting< 1 %
Missing Value (Apply)< 1 %
RowID< 1 %
Rule-based Row Filter< 1 %
Statistics< 1 %
Extract Table Spec< 1 %
Scatter Plot (local)< 1 %
DB Insert< 1 %
DB Table Creator< 1 %
Histogram< 1 %
Line Plot< 1 %
Mask Date/Time (legacy)< 1 %

Views

This node has no views

Workflows

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.

Go to Product

Installation

To use this node in KNIME, install the extension Palladian for KNIME from the below update site following our NodePit Product and Node Installation Guide:

v5.12

A zipped version of the software site can be downloaded here.

Plugin provider: palladian.ws

Plugin version: 3.4.0.202601041906

On NodePit since: 2026-07-07

Last update: 2026-07-31

Tags: Streamable

KNIME versions: Since v3.7

NodePit ExclusiveOnly available on NodePit

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

Try NodePit Runner!