Null field I am trying to add verbiage

[Collin Praster]

Hello I had a vendor ask me if a certain field is blank is to add  Not Provided, I tried a if statement with ct =@null and eq =@null then a copy  with the statement.  Then I get this error.  Also I am still on 5.8

[0:TEST] IF expression parse failed: Expected a relational operator
Error occurred at: ‘=@null’
[0:TEST] IF expression parse failed: Expected a relational operator
Error occurred at: ‘= @null’
[0:TEST] IF expression parse failed: Expected a relational operator
Error occurred at: ‘= @null’

 

Thank you

Topic

[Jay Hammond]

Have you tried:

eq =” (two single quotes)

 

I want to say that I’ve used one of those before.

[Jay Hammond]

Or I’ve also used eq = (nothing after the = sign).

• This reply was modified 3 years, 6 months ago by Jay Hammond.

[Alfred Cox]

Lose the equal sign. You cannot have the “=” and the “@” in the IF statement. It should look something like this:

0(0).EVN(0).#7(0).[0] eq @null &&
0(0).EVN(0).#1(0).[0] eq @null

So, eq @null not eq =@null

[Collin Praster]

Thank you for the responses!  I tried the eq @null without the = and that worked for me.

 

Thank you for the assistance!

[Author]

Replies