You can use condition such as
IF(RIGHT([COL NAME],n) == "pattern", true statmt, false stmt).
The right function would fetch n characters from right i.e, ending n characters from the text in your column.
Use the column in the filter and go to advanced and select does not contain instead and then display the data.
Hope it helps you.