Not equals to :(

[EKotze1615216504]

Hi All

I am pulling my hair out and can't seem to find a working solution for what seems to be a simple problem.

I need to filter out all IDs starting with 7.

So something like ROWID.substr(0,1) != '7'

Thank you for the help

Regards

Edward

[Anonymous]

Hello Edward,

could you please try the below expression

ROWID.startsWith("7")

[Anonymous · Accepted solution]

You can also change your code to:

​!ROWID.substring(0, 1).equals("7")

[EKotze1615216504]

Thank you for the reply but this passes IDs starting with "7" I need to pass all IDs that DO NOT start with "7"

[Anonymous]

please try :

!ROWID.startsWith("7")