topic Re: Not equals to :( in Talend Studio

Not equals to :(

EKotze1615216504 — Fri, 15 Nov 2024 22:27:50 GMT

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 — Thu, 13 Oct 2022 06:43:30 GMT

Hello Edward,

could you please try the below expression

ROWID.startsWith("7")

Anonymous — Thu, 13 Oct 2022 06:48:59 GMT

You can also change your code to:

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

EKotze1615216504 — Thu, 13 Oct 2022 06:50:10 GMT

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 — Thu, 13 Oct 2022 06:55:46 GMT

please try :

!ROWID.startsWith("7")