Hello,
i have the following column:
6. Dezember 2020 12:00:56
19. September 2020 06:50:00
4. Mai 2019 23:44:23
etc and so on
How can I separate these column, so that the date and time are each in a separate column.
new columns:
Column 1 | Column 2
6. Dezember 2020 | 12:00:56
19. September 2020 | 06:50:00
4. Mai 2019 | 23:44:23
thx in advance.
Hi @USCHUKN1ME
Split the column with a Cell Splitter node, and aggregate the seperate date and time column with a Column Aggregator or String Manupulation node.
gr. Hans
Hi Hans,
i used the Cell splitter , but which delimiter I have to use for the column Email-Datum_Arr[l]?
regards
Uwe
Hello,
wow - great!
But a bit more complicated than expected.
Instead of the Table Creator, I set my CSV table. Is that correct?
Regards
Uwe
Yes thats where the input goes.
A simpler version based on the same regular expression, with default nodes:
date time splitter.knwf (25.3 KB)
Thank you rd2575691,
that is easier (for me 
).
I have adjusted the expression for the new column date.
Regards
USCHUKN1ME
You already solved it so congratulations.
For future reference.
This can also be done by 1 Regex Split node
best regards
Thank you !!
