How to use substr in an eval with if

[phamxuantung]

I try to use the query

eval ID = if(ORG="MC",ID=substr(ID,-6),0)

Basically, I want in my result, if ORG="MC", I want to extract the last 6 characters of the field ID that go with it, otherwise stay the same. But the result table always show ID as False if ORG="MC"

How do I fix my query or have to go the other way?

[manjunathmeti]

hi @phamxuantung,

Fixed the query:

| eval ID=if(ORG="MC", substr(ID, -6), ID)