Missing value in notes field of address book but AS finds value

I have several contacts in an address book group. I enumerate through the group to look for MISSING VALUE in the notes field. If I find a note, I process the note and make an email.

Only one contact in my group of 10 contacts has a note. 3 others are registering notes even though I don’t see any.

The error I get is:
Can’t make text 1 of every text item of "" into type Unicode text. Reference Number -1700

Why would AS pick up a notes value if there isn’t one?

Hi,

the default value of a note is missing value, if you write something into the note field and delete it afterwards, the value is empty string (“”)

Thanks Stefan. I was wondering if that was the case.

Thus, is it possible in my condition that you can do an OR clause?

Here is part of my code:


get every person in group (text item 1 of grp) whose note is not missing value OR equal to "")


it is


get every person in group (text item 1 of grp) whose note is not missing value or note is not ""

Thanks Stefan. Worked great.

PS: actually OR with negative input is NAND

get every person in group (text item 1 of grp) whose note is not missing value and note is not ""