Filtering using Contains

[Inactive User]

So I am using the filter tool to remove unwanted records, specifically where there is "test" or "order" in the first or last name column. However, looking at the results it seems to me that it is returning records that contain parts of the string "order" or "test". 

Here is my filter:

Results (notice the last two records):

Any ideas as to why this is happening or how I can fix this?

[Thableaus · Accepted solution]

Hi @Inactive User 

Switch the order of your Contains Function

Contains ([Field], "order")

Cheers,

[Inactive User]

*face palm* 

Thanks!