Hello,
I am a land surveyor and our field crews collect their data and is given to our office personnel as a .csv file. Each point collected in the field is stored with 5 values, comma-delimited (point number, northing, easting, elevation, description). The description of each point will always be on the 5th column. Our crews are supposed to follow a code list or description code for each point collected, this point list includes roughly 80 different descriptions. For example if they are surveying a road, the crew will collect all points taken on the edge of road as CNC ED or fire hydrants as FH, etc. If they accidently save that point with a different name like CONC instead of CNC, the survey software will not recognize that code.
My question is the following, is there something that can be set up to where Excel identifies these “bad” codes and then can be easily fixed instead of scrolling thru looking for mistakes.
I hope I wasn’t too confusing and thanks for your input.
Bookmarks