Flexible Date Reader

A flexible date reader.

This component will attempt to read dates in a variety of free-text formats. The only requirement is that the Day Month and Year order of the received dates is known.

At the moment, this handles months written in ENGLISH only. It would be nice to internationalise this, and I will look at doing that. If you interested in helping with that (even if just for developing/testing with one other language, please contact me on the KNIME forum by posting a message in the Extensions area - @takbb)


i.e. It cannot possible "know" if 01-02-2022 is 2 Jan or 1 Feb (and neither can you unless you "know" your data), so you do have to tell it this part.

Other than that, throw some dates at it which

e.g configure it to month-day-year and then try it with

Feb-01 2022
02-01-2022
02/01/2022
Feb 1st 2022
February 1 2022

You get the idea!

Enjoy

@takbb 24 September 2022

Options

Date Column

Choose the column containing date strings to be interpreted

Source Data date-field sequence

Specify the order of Day, Month and Year in your input data

Locale

Specify the required date locale for your region

Text Ignore List

List of text items to be ignored. (Typically additional words or numeric suffixed used in some languages when writing dates). Delimit with ,

Nodes

• String Manipulation6 ×
• String Manipulation (Variable)3 ×
• Table Row to Variable3 ×
• CASE Switch End2 ×
• Single Selection Configuration2 ×
• Show all 20 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available