Parsing String to Date&Time

[espogian]

Hi, I’m using a CSV Reader followed by a String to Date&Time node.
How would you configure it to parse a string like this:

Tue Jul 17 2018 02:00:00 GMT+0200 (CEST)

[ipazin]

Hi!

I just wouldn’t

I would use string manipulation node to get it to format both myself and Knime find appropriate

Good luck!

Ivan

[ScottF]

In line with what @ipazin suggested, here’s an example workflow. It probably doesn’t do exactly what you need, but maybe you can improve it further.

DateParsingExample.knwf (11.4 KB)

[ipazin]

@ScottF I would just put all these manipulations into one String manipulation node
Ivan