Can I convert MONTH (as three letter text) to digits

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

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
gaseous1
 
Posts: 5
Joined: Sun Mar 25, 2007 2:12 pm

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.
gaseous1
 
Posts: 5
Joined: Sun Mar 25, 2007 2:12 pm

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.
Mr_Noodle
Site Admin
 
Posts: 11195
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City


Return to Support