Converting string to datetime with "month name"

[CDPRIN]

I’m scratching my head on how to convert this string to datetime, it should be fairly simple I guess but I don’t find how to convert the month in text format. Any solution please?

[HansS]

Hi @CDPRIN

Take a look at this wf. Hopte this helps timestamp.knwf (29.5 KB)
gr.
Hans

[armingrudd]

Hi @CDPRIN,

Are the two digits after the month name representing the year? If yes, You can either use the String to Date/Time (legacy) node and input this date format:
ddMMMyy:HH:mm:ss

Or use the String Manipulation node with this expression:
capitalize($column1$, "0123456789")

And then use the String to Date&Time node with the date format I have already mentioned.

Here is an example:
string_date.knwf (21.6 KB)

[CDPRIN]

Hi,
Thanks for your reply. The legacy variant unfortunately had a lot of missing values after transformation (about 20 %), see below.

Using string manipulation together with String to Date&time node worked perfect (0 missing), although I had to add “0” in the string manipulation node :).

Thanks!

[armingrudd]

@CDPRIN

although I had to add “0” in the string manipulation node

Ah, right. Missed it, sorry. I just edited the expression in my first reply.

@CDPRIN

The legacy variant unfortunately had a lot of missing values after transformation (about 20 %), see below.

I just tested the rows with missing value and it worked fine for me.