Before comparing, the formulas are converted to their most basic form. This conversion will affect the original formula in the following ways :
- All REMs are removed
- All white spaces are trimmed
- All CRs are removed (New line and returns)
- All diacritics (accents) are removed
- Everything is converted to UPPERCASE
- 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 |
|
---|