Remove specific value ('-') with null, ? or missing to convert string to date

Hi All,

I need to convert a string to date. The issue I’m facing is that KNIME reads the missing values in the specific date column as ‘-’. When I try to convert the string to date I receive an error as KNIME is not able to parse ‘-’ to date.

image

Would anyone know how I can replace the ‘-’ value with a missing or NULL value so that I can use the string to date&time node?

Kind regards,

Rutger

1 Like

Hi @rutgerverhaar

May be this helps :wink:

Just the following rule is needed in the Rule Engine node:

NOT $Date$ LIKE “-” => $Date$

Best

Ael

3 Likes

Hello @rutgerverhaar,

how do you read your data into KNIME? Some reader nodes have option to define missing value pattern so you can have missing values immediately when data is read into KNIME.

Br,
Ivan

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.