I have the following data returned from Postmark as follows (ISO timestamp):
2020-11-18T05:43:56Z
I am using Find and Replace with “Use a Regex pattern” checked to obtain the individual components of time with the following Regex expression:
^(\d{4})-(\d{2})-(\d{2})T(\d{2}):(\d{2}):(\d{2}):?\d{3}?Z$
Using $1 or $2 as replacement, I am getting the following results from Bubble: 2020-11-18T05:43:56Z.
Shouldn’t the data returned be 2020 for $1 and 11 for $2. I have also verified my results with regex101.com.
The weird thing is the following regex expression works where the major change is to replace “\d” with “.”:
^(.{4})-(.{2})-(.{2})T(.{2}):(.{2}):(.{2}):?.{0,3}Z$