Agree, this is very much needed. We do everything to keep our database clean so we need to be able to filter on the space character in a text property.
I think its crazy its 2024, and there is still not a solution for this but to upgrade to operations Hub. This should be something we can easily accomplish in a list. This is part of data management for many. It looks silly when we are sending out a sequence and it says "Hi Kyle J."