Cell Splitter

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

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?
Regex

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 :smiley:).
I have adjusted the expression for the new column date.

Richtige Ausgabe String Manipulation (Time+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

:ok_hand: :+1:

Thank you !!

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.