How to Identify Cells with Trailing Space

[setzer715]

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.

[LordNeilLord · Accepted solution]

Hey @setzer715,

You could use something like this in the filter tool:

Length([Field1]) = Length(Trim([Field1]))

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[BenMoss]

You could also use the filter tool with the statement

Right([field],1) != " "

[setzer715]

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!