beautypg.com

Date and time pattern matching characters – Kipp&Zonen UVS-E-T UV Radiometers User Manual

Page 53

background image

53

The characters listed below can be used to match a date or time field. Any other character will be scanned as is except when it is a
regular pattern matching character.

18.1 Notes

• Make sure that no non-separator characters at the end of the date and time strings remain unmatched. These characters will be
considered as measurement data
• Use fixed digit symbols in case date and/or time fields are glued together
• The last matched character contributing to a date or time field determines the value of that field. For example, in case H is followed
by s, the second’s time field filled by H will be overwritten by the value matched by s

18.2 Examples

18. Date and Time Pattern Matching Characters

UVIATOR software manual

Character

Description

Y

Multiple digit year

YY

2 digit year

YYYY

4 digit year

M

Multiple digit month

MM

2 digit month

D

Multiple digit day of month

DD

2 digit day of month

d

Multiple digit day of year

ddd

3 digit day of year

h

Multiple digit hour

hh

2 digit hour

H

Fractional hour (sets hour, minute and second)

m

Multiple digit minute

mm

2 digit minute

s

Multiple digit second

ss

2 digit second

A

AM/PM

String

Suitable patterns

2004139 6.5

"YYYYdddH" or "YYYYddd H"

2004139 6.5

"YdH" or "Y d H"

2004.00 139.000 6.5

"Y.[0]+d.[0]+H" or "Y.00d000H"

31/12/2004 23:12:10

"D/M/Y h:m:s" or "DMYhms"

31/12/2004 23:12:10.752

"D/M/Y h:m:s.[0-9]+" or "DMYhms.[0-9]+" (no remaining non-separator characters at the end)

31/7/2004 1:05 PM

"D/M/Y h:m A" or "DMYhmA"