[OKGIS] Data Shift

[Brad Nesom]

I have found some data shift in a dataset that I don't maintain.
however would benefit from it being correct. The scenario is there is
are three year fields in succession (the field type is text). In some
records these are correct. in other records they are shifted one
column left. in still other records they are two or three or four
columns left. the other surrounding data is differing enough to easily
determine if it is a year or not. I know I can manually sort then
select on each column and then calculate that to the correct field.
Does anyone have ideas about automating this a bit to cut out time?
Thanks
Brad