AnsweredAssumed Answered

Joining attribute table to excel sheet

Question asked by mwakomo on Mar 10, 2016
Latest reply on Mar 10, 2016 by wwmiller68

Hello guys,

I want to add a column in my dbase file which will have geometry data (Area)  by joining the dbase file with attribute table.

I have tried to use "FARMER_UNI" from my dbase file to join with "FARMER_UNI" from my attribute table, but the result were not what i wanted.below is an attribute table,




And here is the results i get,




So what i want is the "name" field to be the same as "GPS_Coordi" field, but i cant use those field to do the joining without doing some changes because there is some spelling error such as removing the middle values(12345/6578/ST/1), adding "/" after ST, changing the lower case to upper case(st to ST), and removing spaces between values.


With thanks!