search

EDIorg / ECC

ECC = EML Congruence Checker
5 stars 0 forks source link

Make desired date examples #9

Open twhiteaker opened 6 years ago

twhiteaker commented 6 years ago

It seems like as long as you've got dateTimeFormatString_list.csv, you could add columns for Example and Iso8601, where Iso8601 is the desired date format you'd like the result exported to by your parser.

Some Python code to generate examples

with open('dateTimeFormatString_list.csv') as f:
    lines = [x.strip() for x in f.readlines()]
examples = []
for line in lines:
    example = line.replace('YYYY', '1972') \
        .replace('MM', '04') \
        .replace('DDD', '365') \
        .replace('DD', '01') \
        .replace('hh', '13', 1) \
        .replace('mm', '59', 1) \
        .replace('ss', '04', 1) \
        .replace('.sss', '.001', 1) \
        .replace('hh', '06', 1) \
        .replace('mm', '30', 1)
    examples.append(example)
with open('examples.txt', 'wb') as f:
    f.write('\n'.join(examples))

Examples

1972-04-01 1972-04-01 13:59:04.001 1972-04-01T13:59:04.001 1972-04-01 13:59:04.001Z 1972-04-01T13:59:04.001Z 1972-04-01 13:59:04.001+06:30 1972-04-01T13:59:04.001+06:30 1972-04-01 13:59:04.001+0630 1972-04-01T13:59:04.001+0630 1972-04-01 13:59:04.001+06 1972-04-01T13:59:04.001+06 1972-04-01 13:59:04.001-06:30 1972-04-01T13:59:04.001-06:30 1972-04-01 13:59:04.001-0630 1972-04-01T13:59:04.001-0630 1972-04-01 13:59:04.001-06 1972-04-01T13:59:04.001-06 1972-04-01 135904.001 1972-04-01T135904.001 1972-04-01 135904.001Z 1972-04-01T135904.001Z 1972-04-01 135904.001+06:30 1972-04-01T135904.001+06:30 1972-04-01 135904.001+0630 1972-04-01T135904.001+0630 1972-04-01 135904.001+06 1972-04-01T135904.001+06 1972-04-01 135904.001-06:30 1972-04-01T135904.001-06:30 1972-04-01 135904.001-0630 1972-04-01T135904.001-0630 1972-04-01 135904.001-06 1972-04-01T135904.001-06 1972-04-01 13:59:04 1972-04-01T13:59:04 1972-04-01 13:59:04Z 1972-04-01T13:59:04Z 1972-04-01 13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01 13:59:04+0630 1972-04-01T13:59:04+0630 1972-04-01 13:59:04+06 1972-04-01T13:59:04+06 1972-04-01 13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01 13:59:04-0630 1972-04-01T13:59:04-0630 1972-04-01 13:59:04-06 1972-04-01T13:59:04-06 1972-04-01 135904 1972-04-01T135904 1972-04-01 135904Z 1972-04-01T135904Z 1972-04-01 135904+06:30 1972-04-01T135904+06:30 1972-04-01 135904+0630 1972-04-01T135904+0630 1972-04-01 135904+06 1972-04-01T135904+06 1972-04-01 135904-06:30 1972-04-01T135904-06:30 1972-04-01 135904-0630 1972-04-01T135904-0630 1972-04-01 135904-06 1972-04-01T135904-06 1972-04-01 13:59 1972-04-01T13:59 1972-04-01 13:59Z 1972-04-01T13:59Z 1972-04-01 13:59+06:30 1972-04-01T13:59+06:30 1972-04-01 13:59+0630 1972-04-01T13:59+0630 1972-04-01 13:59+06 1972-04-01T13:59+06 1972-04-01 13:59-06:30 1972-04-01T13:59-06:30 1972-04-01 13:59-0630 1972-04-01T13:59-0630 1972-04-01 13:59-06 1972-04-01T13:59-06 1972-04-01 1359 1972-04-01T1359 1972-04-01 1359Z 1972-04-01T1359Z 1972-04-01 1359+06:30 1972-04-01T1359+06:30 1972-04-01 1359+0630 1972-04-01T1359+0630 1972-04-01 1359+06 1972-04-01T1359+06 1972-04-01 1359-06:30 1972-04-01T1359-06:30 1972-04-01 1359-0630 1972-04-01T1359-0630 1972-04-01 1359-06 1972-04-01T1359-06 1972-04-01 13 1972-04-01T13 1972-04-01 13Z 1972-04-01T13Z 1972-04-01 13+06:59 1972-04-01T13+06:59 1972-04-01 13+0659 1972-04-01T13+0659 1972-04-01 13+06 1972-04-01T13+06 1972-04-01 13-06:59 1972-04-01T13-06:59 1972-04-01 13-0659 1972-04-01T13-0659 1972-04-01 13-06 1972-04-01T13-06 1972 19720401 19720401 13:59:04.001 19720401T13:59:04.001 19720401 13:59:04.001Z 19720401T13:59:04.001Z 19720401 13:59:04.001+06:30 19720401T13:59:04.001+06:30 19720401 13:59:04.001+0630 19720401T13:59:04.001+0630 19720401 13:59:04.001+06 19720401T13:59:04.001+06 19720401 13:59:04.001-06:30 19720401T13:59:04.001-06:30 19720401 13:59:04.001-0630 19720401T13:59:04.001-0630 19720401 13:59:04.001-06 19720401T13:59:04.001-06 19720401 135904.001 19720401T135904.001 19720401 135904.001Z 19720401T135904.001Z 19720401 135904.001+06:30 19720401T135904.001+06:30 19720401 135904.001+0630 19720401T135904.001+0630 19720401 135904.001+06 19720401T135904.001+06 19720401 135904.001-06:30 19720401T135904.001-06:30 19720401 135904.001-0630 19720401T135904.001-0630 19720401 135904.001-06 19720401T135904.001-06 19720401 13:59:04 19720401T13:59:04 19720401 13:59:04Z 19720401T13:59:04Z 19720401 13:59:04+06:30 19720401T13:59:04+06:30 19720401 13:59:04+0630 19720401T13:59:04+0630 19720401 13:59:04+06 19720401T13:59:04+06 19720401 13:59:04-06:30 19720401T13:59:04-06:30 19720401 13:59:04-0630 19720401T13:59:04-0630 19720401 13:59:04-06 19720401T13:59:04-06 19720401 135904 19720401T135904 19720401 135904Z 19720401T135904Z 19720401 135904+06:30 19720401T135904+06:30 19720401 135904+0630 19720401T135904+0630 19720401 135904+06 19720401T135904+06 19720401 135904-06:30 19720401T135904-06:30 19720401 135904-0630 19720401T135904-0630 19720401 135904-06 19720401T135904-06 19720401 13:59 19720401T13:59 19720401 13:59Z 19720401T13:59Z 19720401 13:59+06:30 19720401T13:59+06:30 19720401 13:59+0630 19720401T13:59+0630 19720401 13:59+06 19720401T13:59+06 19720401 13:59-06:30 19720401T13:59-06:30 19720401 13:59-0630 19720401T13:59-0630 19720401 13:59-06 19720401T13:59-06 19720401 1359 19720401T1359 19720401 1359Z 19720401T1359Z 19720401 1359+06:30 19720401T1359+06:30 19720401 1359+0630 19720401T1359+0630 19720401 1359+06 19720401T1359+06 19720401 1359-06:30 19720401T1359-06:30 19720401 1359-0630 19720401T1359-0630 19720401 1359-06 19720401T1359-06 19720401 13 19720401T13 19720401 13Z 19720401T13Z 19720401 13+06:59 19720401T13+06:59 19720401 13+0659 19720401T13+0659 19720401 13+06 19720401T13+06 19720401 13-06:59 19720401T13-06:59 19720401 13-0659 19720401T13-0659 19720401 13-06 19720401T13-06 1972-04 197204 1972-365 1972-365 13:59:04.001 1972-365T13:59:04.001 1972-365 13:59:04.001Z 1972-365T13:59:04.001Z 1972-365 13:59:04.001+06:30 1972-365T13:59:04.001+06:30 1972-365 13:59:04.001+0630 1972-365T13:59:04.001+0630 1972-365 13:59:04.001+06 1972-365T13:59:04.001+06 1972-365 13:59:04.001-06:30 1972-365T13:59:04.001-06:30 1972-365 13:59:04.001-0630 1972-365T13:59:04.001-0630 1972-365 13:59:04.001-06 1972-365T13:59:04.001-06 1972-365 135904.001 1972-365T135904.001 1972-365 135904.001Z 1972-365T135904.001Z 1972-365 135904.001+06:30 1972-365T135904.001+06:30 1972-365 135904.001+0630 1972-365T135904.001+0630 1972-365 135904.001+06 1972-365T135904.001+06 1972-365 135904.001-06:30 1972-365T135904.001-06:30 1972-365 135904.001-0630 1972-365T135904.001-0630 1972-365 135904.001-06 1972-365T135904.001-06 1972-365 13:59:04 1972-365T13:59:04 1972-365 13:59:04Z 1972-365T13:59:04Z 1972-365 13:59:04+06:30 1972-365T13:59:04+06:30 1972-365 13:59:04+0630 1972-365T13:59:04+0630 1972-365 13:59:04+06 1972-365T13:59:04+06 1972-365 13:59:04-06:30 1972-365T13:59:04-06:30 1972-365 13:59:04-0630 1972-365T13:59:04-0630 1972-365 13:59:04-06 1972-365T13:59:04-06 1972-365 135904 1972-365T135904 1972-365 135904Z 1972-365T135904Z 1972-365 135904+06:30 1972-365T135904+06:30 1972-365 135904+0630 1972-365T135904+0630 1972-365 135904+06 1972-365T135904+06 1972-365 135904-06:30 1972-365T135904-06:30 1972-365 135904-0630 1972-365T135904-0630 1972-365 135904-06 1972-365T135904-06 1972-365 13:59 1972-365T13:59 1972-365 13:59Z 1972-365T13:59Z 1972-365 13:59+06:30 1972-365T13:59+06:30 1972-365 13:59+0630 1972-365T13:59+0630 1972-365 13:59+06 1972-365T13:59+06 1972-365 13:59-06:30 1972-365T13:59-06:30 1972-365 13:59-0630 1972-365T13:59-0630 1972-365 13:59-06 1972-365T13:59-06 1972-365 1359 1972-365T1359 1972-365 1359Z 1972-365T1359Z 1972-365 1359+06:30 1972-365T1359+06:30 1972-365 1359+0630 1972-365T1359+0630 1972-365 1359+06 1972-365T1359+06 1972-365 1359-06:30 1972-365T1359-06:30 1972-365 1359-0630 1972-365T1359-0630 1972-365 1359-06 1972-365T1359-06 1972-365 13 1972-365T13 1972-365 13Z 1972-365T13Z 1972-365 13+06:59 1972-365T13+06:59 1972-365 13+0659 1972-365T13+0659 1972-365 13+06 1972-365T13+06 1972-365 13-06:59 1972-365T13-06:59 1972-365 13-0659 1972-365T13-0659 1972-365 13-06 1972-365T13-06 1972365 1972365 13:59:04.001 1972365T13:59:04.001 1972365 13:59:04.001Z 1972365T13:59:04.001Z 1972365 13:59:04.001+06:30 1972365T13:59:04.001+06:30 1972365 13:59:04.001+0630 1972365T13:59:04.001+0630 1972365 13:59:04.001+06 1972365T13:59:04.001+06 1972365 13:59:04.001-06:30 1972365T13:59:04.001-06:30 1972365 13:59:04.001-0630 1972365T13:59:04.001-0630 1972365 13:59:04.001-06 1972365T13:59:04.001-06 1972365 135904.001 1972365T135904.001 1972365 135904.001Z 1972365T135904.001Z 1972365 135904.001+06:30 1972365T135904.001+06:30 1972365 135904.001+0630 1972365T135904.001+0630 1972365 135904.001+06 1972365T135904.001+06 1972365 135904.001-06:30 1972365T135904.001-06:30 1972365 135904.001-0630 1972365T135904.001-0630 1972365 135904.001-06 1972365T135904.001-06 1972365 13:59:04 1972365T13:59:04 1972365 13:59:04Z 1972365T13:59:04Z 1972365 13:59:04+06:30 1972365T13:59:04+06:30 1972365 13:59:04+0630 1972365T13:59:04+0630 1972365 13:59:04+06 1972365T13:59:04+06 1972365 13:59:04-06:30 1972365T13:59:04-06:30 1972365 13:59:04-0630 1972365T13:59:04-0630 1972365 13:59:04-06 1972365T13:59:04-06 1972365 135904 1972365T135904 1972365 135904Z 1972365T135904Z 1972365 135904+06:30 1972365T135904+06:30 1972365 135904+0630 1972365T135904+0630 1972365 135904+06 1972365T135904+06 1972365 135904-06:30 1972365T135904-06:30 1972365 135904-0630 1972365T135904-0630 1972365 135904-06 1972365T135904-06 1972365 13:59 1972365T13:59 1972365 13:59Z 1972365T13:59Z 1972365 13:59+06:30 1972365T13:59+06:30 1972365 13:59+0630 1972365T13:59+0630 1972365 13:59+06 1972365T13:59+06 1972365 13:59-06:30 1972365T13:59-06:30 1972365 13:59-0630 1972365T13:59-0630 1972365 13:59-06 1972365T13:59-06 1972365 1359 1972365T1359 1972365 1359Z 1972365T1359Z 1972365 1359+06:30 1972365T1359+06:30 1972365 1359+0630 1972365T1359+0630 1972365 1359+06 1972365T1359+06 1972365 1359-06:30 1972365T1359-06:30 1972365 1359-0630 1972365T1359-0630 1972365 1359-06 1972365T1359-06 1972365 13 1972365T13 1972365 13Z 1972365T13Z 1972365 13+06:59 1972365T13+06:59 1972365 13+0659 1972365T13+0659 1972365 13+06 1972365T13+06 1972365 13-06:59 1972365T13-06:59 1972365 13-0659 1972365T13-0659 1972365 13-06 1972365T13-06

The first 227 ISO results (b/c my parser broke after that)

1972-04-01T00:00:00 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04 1972-04-01T13:59:04 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:00 1972-04-01T13:59:04-06:00 1972-04-01T13:59:04 1972-04-01T13:59:04 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:00 1972-04-01T13:59:04-06:00 1972-04-01T13:59:00 1972-04-01T13:59:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:00 1972-04-01T13:59:00-06:00 1972-04-01T13:59:00 1972-04-01T13:59:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:00 1972-04-01T13:59:00-06:00 1972-04-01T13:00:00 1972-04-01T13:00:00 1972-04-01T13:00:00+00:00 1972-04-01T13:00:00+00:00 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:00 1972-04-01T13:00:00+06:00 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:00 1972-04-01T13:00:00-06:00 1972-03-06T00:00:00 1972-04-01T00:00:00 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+00:00 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:30 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000+06:00 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:30 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04.001000-06:00 1972-04-01T13:59:04 1972-04-01T13:59:04 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:00 1972-04-01T13:59:04-06:00 1972-04-01T13:59:04 1972-04-01T13:59:04 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+00:00 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:30 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04+06:00 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:30 1972-04-01T13:59:04-06:00 1972-04-01T13:59:04-06:00 1972-04-01T13:59:00 1972-04-01T13:59:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:00 1972-04-01T13:59:00-06:00 1972-04-01T13:59:00 1972-04-01T13:59:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+00:00 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:30 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00+06:00 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:30 1972-04-01T13:59:00-06:00 1972-04-01T13:59:00-06:00 1972-04-01T13:00:00 1972-04-01T13:00:00 1972-04-01T13:00:00+00:00 1972-04-01T13:00:00+00:00 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:59 1972-04-01T13:00:00+06:00 1972-04-01T13:00:00+06:00 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:59 1972-04-01T13:00:00-06:00 1972-04-01T13:00:00-06:00