Ytria logo DOCUMENTATION
⚠ This page requires javascript enabled in browser
viewEZ / Features / Columns / Search and analyze columns

 

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