AnsweredAssumed Answered

DevTest Date Pattern for yyyyMMddHHmmss

Question asked by howst04 Employee on May 18, 2017

Tried to create a new entry for the date pattern yyyyMMddHHmmss

 

Nothing happens when I try to create a magic date for example value 20170420053501 

 

The below is configuration I have applied in local properties most notable change is timestampformat. Any ideas why this is not working?

 

#================================================
# DevTest DATE-CHECKER PROPERTIES
# These are the set of properties that are used by the DevTest VSE date utilities, to
# figure out which date patterns are going to be considered valid for date sensitivity
# conversions.
#================================================
# Each of the following entries represents a regular expression that will be considered
# valid as a part of date, by VSE.
lisa.vse.datechecker.dayregex=(([12]\\d)|(3[01])|(0?[1-9]))
lisa.vse.datechecker.monthnumberregex=((1[012])|(0\\d)|0[1-9]|[1-9])
lisa.vse.datechecker.monthalpharegex=(\\bJAN\\b|\\bFEB\\b|\\bMAR\\b|\\bAPR\\b|\\bMAY\\b|\\bJUN\\b|\\bJUL\\b|\\bAUG\\b|\\bSEP\\b|\\bOCT\\b|\\bNOV\\b|\\bDEC\\b)
lisa.vse.datechecker.yearlongregex=\\d\\d\\d\\d
lisa.vse.datechecker.yearshortregex=\\d\\d
lisa.vse.datechecker.timeregex=(\\s?(([012]?\\d)|(2[0123])):(([012345]\\d)|(60)):(([012345]\\d)|(60)))
lisa.vse.datechecker.time.hhmmssregex=(([012]?\\d)|(2[0123])):(([012345]\\d)|(60)):(([012345]\\d)|(60))
lisa.vse.datechecker.time.millisregex=(([012]?\\d)|(2[0123])):(([012345]\\d)|(60)):(([012345]\\d)|(60))\\.((\\d\\d\\d)|0)
lisa.vse.datechecker.time.millis.zoneregex=(([012]?\\d)|(2[0123])):(([012345]\\d)|(60)):(([012345]\\d)|(60))\\.((\\d\\d\\d)|0)\\s([A-Za-z][A-Za-z][A-Za-z])
lisa.vse.datechecker.wstimestampregex=\\d\\d\\d\\d-((1[012])|(0\\d)|0[1-9]|[1-9])-(([12]\\d)|(3[01])|(0?[1-9]))T(([012]?\\d)|(2[0123])):(([012345]\\d)|(60)):(([012345]\\d)|(60))\\.\\d\\d\\d[-+]\\d\\d\\d\\d
#lisa.vse.datechecker.timestampregex=\\d\\d\\d\\d-((1[012])|(0\\d)|0[1-9]|[1-9])-(([12]\\d)|(3[01])|(0?[1-9]))T(([012]?\\d)|(2[0123])):(([012345]\\d)|(60)):(([012345]\\d)|(60))
lisa.vse.datechecker.timestampregex=\\d\\d\\d\\d-((1[012])|(0\\d)|0[1-9]|[1-9])-(([12]\\d)|(3[01])|(0?[1-9]))(([012]?\\d)|(2[0123]))(([012345]\\d)|(60))(([012345]\\d)|(60))
lisa.vse.datechecker.ddmmmyyyyregex=(([12]\\d)|(3[01])|(0?[1-9]))(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)\\d\\d\\d\\d
lisa.vse.datechecker.mmmddyyyyregex=(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)(([12]\\d)|(3[01])|(0?[1-9]))\\d\\d\\d\\d
lisa.vse.datechecker.yyyyddmmmregex=\\d\\d\\d\\d(([12]\\d)|(3[01])|(0?[1-9]))(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)
lisa.vse.datechecker.yyyymmmddregex=\\d\\d\\d\\d(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)(([12]\\d)|(3[01])|(0?[1-9]))
lisa.vse.datechecker.ddmmmregex=(([12]\\d)|(3[01])|(0?[1-9]))(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)
lisa.vse.datechecker.mmmddregex=(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)(([12]\\d)|(3[01])|(0?[1-9]))
lisa.vse.datechecker.ddmmmyyregex=(([12]\\d)|(3[01])|(0?[1-9]))(JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC)\\d\\d
# Each of the following entries represents a valid pattern of a part of date, in the vse
lisa.vse.datechecker.dayformat=dd
lisa.vse.datechecker.monthnumberformat=MM
lisa.vse.datechecker.monthalphaformat=MMM
lisa.vse.datechecker.yearlongformat=yyyy
lisa.vse.datechecker.yearshortformat=yy
lisa.vse.datechecker.timeformat=HH:mm:ss
lisa.vse.datechecker.time.hhmmssformat=HH:mm:ss
lisa.vse.datechecker.time.millisformat=HH:mm:ss.SSS
lisa.vse.datechecker.time.millis.zoneformat=HH:mm:ss.SSS z
lisa.vse.datechecker.wstimestampformat=yyyy-MM-dd'T'HH:mm:ss.SSSZ
#lisa.vse.datechecker.timestampformat=yyyy-MM-dd'T'HH:mm:ss
lisa.vse.datechecker.timestampformat=yyyyMMddHHmmss
# The following are some of the date patterns that can't be constructed by using a combination
# for the above patterns that involve at least day, month & year part.
lisa.vse.datechecker.mmmddyyyy.separatorformat=MMM*dd*yyyy
lisa.vse.datechecker.mmddyyyy.separatorformat=MM*dd*yyyy
lisa.vse.datechecker.ddmmmyyyy.separatorformat=dd*MMM*yyyy
lisa.vse.datechecker.ddmmyyyy.separatorformat=dd*MM*yyyy
lisa.vse.datechecker.yyyymmmdd.separatorformat=yyyy*MMM*dd
lisa.vse.datechecker.yyyymmdd.separatorformat=yyyy*MM*dd
lisa.vse.datechecker.ddmmmyyyyformat=ddMMMyyyy
lisa.vse.datechecker.mmmddyyyyformat=MMMddyyyy
lisa.vse.datechecker.yyyyddmmmformat=yyyyddMMM
lisa.vse.datechecker.yyyymmmddformat=yyyyMMMdd
lisa.vse.datechecker.ddmmmyyformat=ddMMMyy
lisa.vse.datechecker.ddmmmformat=ddMMM
lisa.vse.datechecker.mmmddformat=MMMdd
# This represent the valid separator characters that can be used within the date formats.
# For example, 10/15/2001 uses '/' as a separator.
lisa.vse.datechecker.seperators=- /.
# Priority order decides what order we should use to match the date pattern. The asterisk will
# be replaced by the separator characters defined by the "separators" property. For example,
# MM*dd*yy will generate four date patterns: "MM-dd-yyyy", "MM dd yyyy", "MM/dd/yyyy", "MM.dd.yyyy".
lisa.vse.datechecker.top.priorityorder=lisa.vse.datechecker.wstimestampformat
lisa.vse.datechecker.date.priorityorder=lisa.vse.datechecker.mmmddyyyy.separatorformat&\
lisa.vse.datechecker.timestampformat&\
lisa.vse.datechecker.mmddyyyy.separatorformat&\
lisa.vse.datechecker.ddmmmyyyy.separatorformat&\
lisa.vse.datechecker.ddmmyyyy.separatorformat&\
lisa.vse.datechecker.yyyymmmdd.separatorformat&\
lisa.vse.datechecker.yyyymmdd.separatorformat&\
lisa.vse.datechecker.mmmddyyyyformat&\
lisa.vse.datechecker.ddmmmyyyyformat&\
lisa.vse.datechecker.yyyyddmmmformat&\
lisa.vse.datechecker.yyyymmmddformat&\
lisa.vse.datechecker.ddmmmyyformat
lisa.vse.datechecker.time.priorityorder=lisa.vse.datechecker.time.millis.zoneformat&\
lisa.vse.datechecker.time.millisformat&\
lisa.vse.datechecker.time.tenthsformat&\
lisa.vse.datechecker.time.hhmmssformat
lisa.vse.datechecker.bottom.priorityorder=lisa.vse.datechecker.mmmddformat&\
lisa.vse.datechecker.ddmmmformat

Outcomes