Convert Expression

[thunderbolt983]

I have a date field that read as this:

21-jan-2019

I am trying to find a way to convert it to the following:

21.jan.2019

I have tried it with the regex tool in Knime but Im unable to determine the syntax well.

Any idea?

Thank you.

[quaeler]

You could use the String Manipulation node, using the replace(str, search, replace) function.

[ipazin]

Hi there!

You can also have it in a Date format which allows you to use Date&Time nodes on that column

Br,
Ivan