Template:Time zone/regex

Some regular expressions that may help working with the tz database data

If performed in this order, it will convert +- to NSEW

search ^-

replace S

search ^+

replace N

search -

replace W

search +

replace E

If +- is converted to NSEW:

search ([NS])([0-9]{2})([0-9]{2})[0-9]{0,2}([EW])([0-9]{3})([0-9]{2})[0-9]{0,2}

replace $2|$3|$1|$5|$6|$4

result: all entries will have DD|MM|NS|DDD|MM|EW format - needed by template:coord

Converted data might be stored at template:Time zone/coord