@Jared Cohen @Jonathan Chinitz @Donald Pannese
i have a requirement to convert a date filed with the below input format.
Source Date:2019-10-01T16:06:27.5859855+02:00
i need to convert the above date to ISO string and drop the millseconds
Regex:(^\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2})\.\d{7}([\+\-]\d{2}:\d{2})
I used capturing groups to match all the above date and how do i select the values only from the capturing groups so that the output field show the below date format.
yyyy-mm-dd'T'HH:mm:ss'Z'
I believe if you use a Date Conversion stage with the following pattern/replacement string:
you will get the desired result:
Let me know if this works for you.
This was the wrong answer
This is the right one. I am attaching a pipeline snippet that does the following:
You could probably do this much quicker with a Javascript stage :-)
Thanks Jon. I was doing the same ,but want to know if there is a way we can select the capturing group in regex and map it to date value in this stage.
I don't believe that is possible. I'll ask ENG and see what they say.
