[OKGIS] Re: Data Shift

[Brad Nesom]

I have attached an example of what I want to accomplish.
jpg.

On Wed, Apr 2, 2008 at 10:42 AM, Brad Nesom <bnesom at meshekengr.com> wrote:
> 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
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: yearShift.JPG
Type: image/jpeg
Size: 94288 bytes
Desc: not available
Url : http://gis.ou.edu/pipermail/okgis/attachments/20080402/16163e8a/yearShift.jpe