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
- " 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.