End with characters in column

Question

How to show data in table if column values end with characters?

Answer 1

Hi Rahul,

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.

OR

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.