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.
HansS
January 13, 2021, 12:49pm
2
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
date time splitter.knwf (17.8 KB)
Hello,
Does this help?
1 Like
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
1 Like
You already solved it so congratulations.
For future reference.
This can also be done by 1 Regex Split node
best regards
1 Like
system
Closed
July 15, 2021, 8:34pm
10
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.