AnsweredAssumed Answered

Field Calculator: Text White Space Bug - Pro 2.5.1

Question asked by romahicks on May 13, 2020
Latest reply on May 18, 2020 by KKramer-esristaff

I am working on trying to get a dataset that was lazily collected and processed by a contractor, fixed. There are values in the fields that have lot of leading, trailing whitespace and in some cases both leading and trailing whitespace.  At time more than one whitespace.


  • I would expect: the Insert Values control in the Field Calculator to show all unique values found in the field.
  • What actually happens: the Insert Value control ignores all whitespaces and incorrectly identifies different values as a single value


The values:

  • "Yes"
  • " Yes"
  • "Yes "
  • "Yes  "

Are all different values and should be treated as such.


I wanted to report a bug but the support page claims I don't belong to a organisation, which I do. And I shouldn't need a support case to report a bug, I don't need someone to fawn over me, it just needs better programming, unit testing and fixed.