{"id":7137,"date":"2019-01-04T05:27:25","date_gmt":"2019-01-04T05:27:25","guid":{"rendered":"https:\/\/www.appservgrid.com\/paw92\/?p=7137"},"modified":"2019-01-08T11:35:12","modified_gmt":"2019-01-08T11:35:12","slug":"changing-the-month-format-a-fairly-general-solution","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/01\/04\/changing-the-month-format-a-fairly-general-solution\/","title":{"rendered":"Changing the month format: a fairly general solution"},"content":{"rendered":"

\"banner\"For a full list of BASHing data<\/em> blog posts, see the index page<\/a>.<\/p>\n

I sometimes need to change the month format in a dataset, for instance from “Jan” to “01”, or “3” to “March”. There are various clever ways to do this on the command line, but I’m not good at remembering clever. To save time I wrote a table with the 6 different month formats I see most often. It’s the table you see below, and if you highlight and copy it, you should be able to paste it into a text editor as a tab-separated table. Save the file as “months”.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
1<\/td>\n01<\/td>\nJan<\/td>\nJanuary<\/td>\ni<\/td>\nI<\/td>\n<\/tr>\n
2<\/td>\n02<\/td>\nFeb<\/td>\nFebruary<\/td>\nii<\/td>\nII<\/td>\n<\/tr>\n
3<\/td>\n03<\/td>\nMar<\/td>\nMarch<\/td>\niii<\/td>\nIII<\/td>\n<\/tr>\n
4<\/td>\n04<\/td>\nApr<\/td>\nApril<\/td>\niv<\/td>\nIV<\/td>\n<\/tr>\n
5<\/td>\n05<\/td>\nMay<\/td>\nMay<\/td>\nv<\/td>\nV<\/td>\n<\/tr>\n
6<\/td>\n06<\/td>\nJun<\/td>\nJune<\/td>\nvi<\/td>\nVI<\/td>\n<\/tr>\n
7<\/td>\n07<\/td>\nJul<\/td>\nJuly<\/td>\nvii<\/td>\nVII<\/td>\n<\/tr>\n
8<\/td>\n08<\/td>\nAug<\/td>\nAugust<\/td>\nviii<\/td>\nVIII<\/td>\n<\/tr>\n
9<\/td>\n09<\/td>\nSep<\/td>\nSeptember<\/td>\nix<\/td>\nIX<\/td>\n<\/tr>\n
10<\/td>\n10<\/td>\nOct<\/td>\nOctober<\/td>\nx<\/td>\nX<\/td>\n<\/tr>\n
11<\/td>\n11<\/td>\nNov<\/td>\nNovember<\/td>\nxi<\/td>\nXI<\/td>\n<\/tr>\n
12<\/td>\n12<\/td>\nDec<\/td>\nDecember<\/td>\nxii<\/td>\nXII<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

My general strategy is to use AWK to change formats, and to load “months” into an appropriate array in the AWK command. Below are a few examples.<\/p>\n

Expand abbreviated month<\/p>\n

\"first\"<\/p>\n

awk ‘FNR==NR \/-\/ ‘ months file<\/p>\n

Split “full” date into ISO 8601 components<\/p>\n

\"second\"<\/p>\n

awk -F”t” ‘FNR==NR FNR==1 FNR>1 ‘ months file<\/p>\n

Convert “full American” date into Roman month-numeral date<\/p>\n

\"third\"<\/p>\n

awk -F”t” ‘FNR==NR FNR==1 FNR>1 ‘ months file<\/p>\n

Convert date range into ISO 8601 interval date<\/p>\n

\"fourth\"<\/p>\n

awk ‘FNR==NR \/[0-9]-[0-9]\/ \/ – \/ && length($0)<21 \/ – \/ && length($0)>21 ‘ months file<\/p>\n

To remind myself which fields are which in “months”, I just cat the file before building the AWK command:<\/p>\n

\"months\"<\/p>\n

Last update: 2018-12-30<\/p>\n

Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

For a full list of BASHing data blog posts, see the index page. I sometimes need to change the month format in a dataset, for instance from “Jan” to “01”, or “3” to “March”. There are various clever ways to do this on the command line, but I’m not good at remembering clever. To save … <\/p>\n

Continue reading “Changing the month format: a fairly general solution”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7137","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/7137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=7137"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/7137\/revisions"}],"predecessor-version":[{"id":7457,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/7137\/revisions\/7457"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=7137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=7137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=7137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}