Expand the datetime-parse function to include 3 letters months

Answered

Follow

Maximilien Sauban

• March 25, 2022 12:07

As it is the datetime-parse function does not allow parsing of date format with alphanumerics like: “Thu, 11 Mar 2021 10:44:07 GMT”. While the leading day and trailing GMT are easily dealt with, retrieving the month is difficult without convoluted DTL operations. Adding lettered month to the regular expression tokens would help.

0

• Official comment

  

  Geir Ove Grønmo

  • May 03, 2022 11:57

  It is highly unlikely that we'll ever add support for localized names of days. A workaround would be to remove the known day strings with the help of the replace function like this:

  ["replace", {"Mon, ": "", "Tue, ": "", ...}, "_S.value"]]
  

  Comment actions Permalink
• 

  Maximilien Sauban

  • May 03, 2022 14:35

  How about the month? The day wasn't really an issue.

  0

  Comment actions Permalink
• 

  Geir Ove Grønmo

  • May 11, 2022 13:33

  How about nesting the replace calls like this, so you first strip off the days and then the months?

  ["replace", {"Jan ": "", "Feb ": "", ...}, ["replace", {"Mon, ": "", "Tue, ": "", ...}, "_S.value"]]

  0

  Comment actions Permalink

Please sign in to leave a comment.