How do I write a regex for a date with the time zone, and why i am not able to extract the following field?


#1

Hi there, I need help in writing the regex for date format with time zone.

Format :

  1. 11 Sep 2018 18:40:42 (GMT +0200)

regex :

  1. ^\d{2}\s\w{3}\s\d{4}\s(\d{2}:\d{2}:\d{2})\s\d{4}\s
  2. how to add (GMT +0200) in regex

Also, I would like to add this time value in a different field?


#2

Hi,

Why would you want to make it more complicated than it needs to be? You can simply switch to any time zone and have the respective time duration of events as per the selected time zone:
DNIF%20%20%20Analytics%20Console%20(14)

DNIF%20%20%20Analytics%20Console%20(15)