Breadcrumbs

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 formula

REM {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 found

5
From, AltFrom, readers, ExpireDate, Subject