Change 2 date format in a column

KNIME Analytics Platform
2

Hello @takdirzd and welcome to the KNIME forum
A possible one node solution is String Manipulation with the following code:

string(
	regexMatcher($text$, ".*[.]\\d{4}").equals("True")
	? $text$
	: join(
		substr($text$, 8, 2)
		, "."
		,substr($text$, 5, 2)
		, "."
		,substr($text$, 0, 4)
		)
)

code source

image

Other possible approach would be Column Expressions…
With some more nodes you would be able to split the data based in a logical condition, modify target data, append back and resort if necessary.

BR

4 Likes