As an easy way to group accidents by year, the data has a field with
simply the year of the accident. Unfortunately, they've chosen to
enter 2 date years, rather than 4 date years. This presents 2
problems:
1) 9999 is sometimes entered as shorthand for "date unknown"
2) There are other weird things in there too, (like I93 for an
accident in 1993)
What I'd like to do is clean this up to 4 digit years; I realize some
things will just have to be hand edited, but is there a way to batch
replace -00- with -2000-?
--
Robin
--------------------------------------------------------------
W. Robert Newberry, IV CIH, CHMM
Chief Environmental Health and Safety Officer
Clemson University
