If I have a cell with information like "DOOR ALARM NSI" that has trailing space how can I filter that out WITHOUT trimming it. I need to identify those for action, not modify the data.
Solved! Go to Solution.
Hey @setzer715,
You could use something like this in the filter tool:
Length([Field1]) = Length(Trim([Field1]))
Part time Tableau, Part Time Alteryx. Full Time Awesome
You could also use the filter tool with the statement
Right([field],1) != " "
Thank you both. Both solutions worked. I went with Length([Field1]) = Length(Trim([Field1])) because this identified both trailing and leading spaces. I wasn't even aware that I had leading spaces until running this filter!