How to parse JSON Date Notation /DATE(...)/

Hi,

I want to parse a JSON file, where the Date is denoted as e.g. /Date(1563148800000)/.
So far, I was not able to translate it in KNIME into a “real” date format.

Is there a solution for this?

Thanks alot!

Hi @Residentstiefel,

looks like you have a (millisecond) timestamp in UNIX format.
Look at this workflow, which should transform your input.

best, Tommy

2 Likes

It works!
Absolutely fantastic!

Thanks alot for helping out!

1 Like

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