IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

How to parse a standard US data string? Options · View
szi
Posted: Thursday, April 9, 2020 11:17:56 AM
Rank: Newbie

Joined: 3/6/2020
Posts: 3
I have a string field with a standard US date using abbreviated months.

Example: Dec 3 14:28:51 2019 GMT

How can I parse this date in order to convert it into a different format?
K101
Posted: Tuesday, April 21, 2020 6:24:58 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 563
If you first append the text “+00:00” to your string’s “GMT” ending, then you can parse the datetime using the format string “[MNn] [D] [H]:[m]:[s] [Y] [z]”.

Output: 2019-12-03T14:28:51Z

File Attachment(s):
example.mfd (3kb) downloaded 129 time(s).

K101 attached the following image(s):
example.png

Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.