[OKGIS] Re: Data Shift

[Robert Stokes]

Wow, what a mess! How many records are we talking about here?

The only thing that I can think of that might be feasible would be to
concatenate all of the fields into one composite field, maybe separated
by commas. Then you might be able to use TRIM()/MID() to get rid of the
junk. Then sort the data...this would get all the two, three, four, etc.
columned data together. Then you could do another field calculation
using MID() to get the data into the desired fields. This may be more
time consuming or difficult than the original! :)

Anyway, that is the best I can come up with right now. Good Luck!


------------------------------------------------------
Robert Stokes
President, Topographic Mapping Company

OK GITA Chapter President
OK SCAUG Steering Committee




-----Original Message-----
From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu]
On Behalf Of Brad Nesom
Sent: Wednesday, April 02, 2008 10:55 AM
To: Oklahoma GIS Community
Subject: [OKGIS] Re: Data Shift

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
>