Null field I am trying to add verbiage

Tagged: Cloverleaf

This topic has 4 replies, 3 voices, and was last updated 3 years, 5 months ago by Collin Praster.

Creator

Topic
April 5, 2021 at 2:16 pm #118709

Collin Praster
Participant

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
Creator

Topic

Viewing 3 reply threads

Author

Replies
- April 5, 2021 at 2:36 pm #118711
  
  Jay Hammond
  Participant
  
  Have you tried:
  
  eq =” (two single quotes)
  
  I want to say that I’ve used one of those before.
- April 5, 2021 at 2:41 pm #118712
  Jay Hammond
  Participant
  Or I’ve also used eq = (nothing after the = sign).
  - This reply was modified 3 years, 5 months ago by Jay Hammond.
- April 5, 2021 at 3:00 pm #118714
  
  Alfred Cox
  Participant
  
  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
- April 5, 2021 at 4:40 pm #118715
  
  Collin Praster
  Participant
  
  Thank you for the responses! I tried the eq @null without the = and that worked for me.
  
  Thank you for the assistance!
Author

Replies

Viewing 3 reply threads

You must be logged in to reply to this topic.