Filtering Records Having a Space in a Field
Editor for Fixed Width, Csv and Existing Xml files.
Status: Beta
Brought to you by:
bruce_a_martin
Menu
▾
▴
#9 Filtering Records Having a Space in a Field
Hi, I have been trying to filter records on a field having space or blank but have not had any luck. I have been able to get records with a field with a space by specifying field being >= to a hard space that I enter in the value field but I get all records. I just want to get those with the field having a space or blank. I have tried putting in the value field a '' or "" or entered space along with the = operator but nothing seems to work for me. I have checked the How To documentation and I do not see any way to do this. I have googled for this and do not see it addressed anywhere. Is there a way? Thanks.
Discussion
Anonymous
If you are trying to find fields that are totally blank use the is missing. But you must specify
a field.
You can use Contains and enter a space character in the value field. This will not find fields with spaces at the end of the field. Trailing spaces are always trimmed before any test.
A third option may be to use a "script" to the filter. Take Utilities >>> Script Build >>> Filter Script,
see attached picture. This will build a skelton filter script.
Can you provide more details on what file you are filytering and what exactly you are filtering on ???
A Csv version of the file would be usefull (Export >>> Csv)
View and moderate all "support-requests Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Support Requests"
The is empty operator (i did not see is missing) is works for the filtering I'm trying to do.
This item can be closed. Thanks.
The is empty operator (did not see is missing) works for what I'm trying to do. This item can be closed. Thanks for your support.
Thanks for letting me know; I will add a RegularExpression operator in the next vesion