RegExp date reformatting
Posted: Mon Sep 13, 2004 7:47 pm
Given a date in YYYYMMDD form, it might be useful to be able to convert it to
MM/DD/YYYY form (as an Access import for example).
Assuming that there's no other 8 digit numbers in the file:
find: \([0-9]\{4\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)
replace: \2/\3/\1
MM/DD/YYYY form (as an Access import for example).
Assuming that there's no other 8 digit numbers in the file:
find: \([0-9]\{4\}\)\([0-9]\{2\}\)\([0-9]\{2\}\)
replace: \2/\3/\1