hey guys, I want to ask.
how can I change this format like in the picture, “yyyy.mm.dd” to “dd.mm.yyyy”? there are 2 date format, but i just want to change it in 1 format only.
example, the data is :
17.01.2022
2022.04.01
…
and I want the output like this,
17.01.2022
01.04.2022
…
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.
yeah I think the same way. I can split them into 2 types date format, and merge them later. but I think it’s takes much time to do, and there will be a lot of nodes … thank you!
@denisfi you are right, I almost forgot regexReplace() is conditional itself.
Good catch!! regexReplace($text$, "(\\d{4}).(\\d{2}).(\\d{2})", "$3.$2.$1")
BR