Can I convert MONTH (as three letter text) to digits
Posted:
Thu May 13, 2021 10:42 amby gaseous1
I have statements containing a three-letter month abbreviation (JAN, FEB, MAR, ...). I'd like to convert those abbreviations to the equivalent two digit numeral (01, 02, 03, ...). Can I do this via the renaming mechanisms in Hazel?
Thanks,
Eric
Re: Can I convert MONTH (as three letter text) to digits
Posted:
Thu May 13, 2021 10:56 amby gaseous1
Figured it out. Used the "Replace Text" on the Custom Match Pattern I created to convert Jan to 01, Feb to 02 and the like.
Re: Can I convert MONTH (as three letter text) to digits
Posted:
Fri May 14, 2021 10:19 amby Mr_Noodle
If you use a custom date attribute, you can match it as a date. Then when re-using it in whichever pattern, you can set the date format to use numeric months instead of textual ones.