Most likely, one (or more) of your records has nothing but a space in this field.
I understand and agree. I would like to know if there is a method to detect which record is causing the problem. A visual check does not reveal an invisible entry.
Try searching for *@ then show omitted.
To exand on this great idea, one might want to also skip records with blank fields, right? You can add a second find request.
Requests - Add new request
... then show omitted
I mention it only because if you have a lot of blank records, no sense trying to strip them if they don't need to be. :smileyhappy: