LIKE operator in Graphical View

[Former Member]

Hello All,

I have a requirement to use a LIKE operator in Graphical calculation view. I can use this operator in Scripted view but Graphical view doesn't support this keyword. Can anyone help me out in this?

Regards,

Alok

[Former Member · Accepted solution]

Hi Alok,

There is an operator called Match(Col_name, *pattern*) in Graphical views instead of LIKE operator. And Use '*' to match any character unlike '%' in LIKE operator.

Regards,

Akshay

[former_member182302 · Accepted solution]

Hi Alok,

Have a look on this blog:

Where i have used "match" operator ( to implement filter condition similar to using LIKE)

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Thanks Akshay for the Quick Answer And thanks Krishna for sharing the useful Blog

Regards,

Alok

[asyikin]

Hi may I know what is the opposite of match() operator, I want to filter only values that does not match to a pattern.