Starts with characters in column

Question

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

Answer 1

Hi Rahul,

You can use condition such as

IF(LEFT([COL NAME],n) == "pattern", true statmt, false stmt).

The left function would fetch n characters from left i.e, starting n characters from the text in your column.

OR

Use the column in the filter and go to advanced and select starts with and then display the data.

Hope it helps you.