Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Make desired date examples #9

Open
twhiteaker opened this issue Mar 6, 2018 · 0 comments
Open

Make desired date examples #9

twhiteaker opened this issue Mar 6, 2018 · 0 comments

Comments

@twhiteaker
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@twhiteaker