Extract date from text and repeat the date above in the column

Hi dear friends, I am a knime beginner. I have a file which you can see in attached image. And I would like to extract dates from column 2 string in a new column and repeat them below in the same range in order to have the date corresponding to each row.

Hi there @NATTE,

welcome to KNIME Community!

For converting string to date&time you should use String to Date&Time node. There you can disable option Fail on error so node doesn’t fail on cells not properly formatted which will be missing (red question mark). Then use Missing Value node with Previous Value option. Give it a try and if any questions/problems I can make you an example :wink:

Happy KNIMEing!

Br,
Ivan

1 Like

hello @ipazin, I tried the two node that you recommended but I did not get the expected result.
you can see the results in an attached file. thank you for your help.

Hi @NATTE,

seems to me your date format is wrong. Should be dd/MM/yyyy, shouldn’t it? Also in Missing Value node there is tab Column Settings where you can define how to deal with missing values on column basis.

Br,
Ivan

3 Likes

Hi @ipazin thanks for your help. I got the expected result.
you can see the result in an attached file.
You are a master.

really, thank you

3 Likes

HI @NATTE,

glad you made it :+1:

Br,
Ivan

1 Like

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