I would like to get some help on the following issue that I encountered in ArcGis 10.3
The objective is to look through the whole string and remove just the "." from the string
Object ID Field
I've tried using the following code which resulted in the all the last characters being removed instead of just "." :
Trim( LEFT ([Field], LEN( [Field]) -1))
I've also tried the code below which prompted an error message "Type mismatch" for both iif and InStr :
Trim(Left([Field], iif((InStr([Field], ".") = LEN([Field])), InStr([Field], ".")-1, LEN([Field]))))
I am using the Field Calculator in ArcGis 10.3.
Thanks for any help in advance.