Skip to main content
Skip table of contents

Formula Compare Method

Before comparing, the formulas are converted to their most basic form. This conversion will affect the original formula in the following ways :

  1. All REMs are removed
  2. All white spaces are trimmed
  3. All CRs are removed (New line and returns)
  4. All diacritics (accents) are removed
  5. Everything is converted to UPPERCASE
  6. Builds a field list used in the formula
EXAMPLE


Original formulaREM {the following is for alternate name support};
CNFrom := @Name([CN]; From);
CNAltFrom := @Name([CN]; AltFrom);
Alternatename := @If(AltFrom != "" & AltFrom != From; " [" + CNAltFrom + "]"; "");

@If(readers!= "";"PRIVATE: ";
ExpireDate !="";"EXPIRED: ";
"") +
@If(Subject = ""; "Untitled"; Subject) + " (" + CNFrom + Alternatename + ")"
Simplified formula for comparing
(all on one line)
;CNFROM:=@NAME([CN];FROM);CNALTFROM:=@NAME([CN];ALTFROM);ALTERN
ATENAME:=@IF(ALTFROM!=""&ALTFROM!=FROM;"["+CNALTFROM+"]";"");@IF(RE
ADERS!="";"PRIVATE:";EXPIREDATE!="";"EXPIRED:";"")+@IF(SUBJECT="";"UNTITL
ED";SUBJECT)+"("+CNFROM+ALTERNATENAME+")"
Fields found5
From, AltFrom, readers, ExpireDate, Subject
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.