Lotus Domino Designer 8.5 Help - Examples: @Compare

FORMULA LANGUAGE

Examples: @Compare
1. This action compares a list to the value "N" and displays the result. Boston and Moscow result in -1 (less than N), Tokyo results in 1 (greater than N), and n and N result in 0.

list := "Boston" : "Tokyo" : "Moscow" : "N" : "n"; result := @text(@compare(list; "N"; [CaseInsensitive])); @Prompt([OKCANCELLIST] : [NOSORT]; "Result"; ""; ""; list + " (" + result + ")")

2. This computed field formula compares the two multi-value fields Name1 and Name2 and posts the result as its value. Text is substituted for the numeric result values.

@If(Names1 = "" | Names2 = ""; ""; @do( comp1 := @Compare(Names1; Names2; [CASEINSENSITIVE] : [ACCENTINSENSITIVE]); comp2 := @Replace(@Text(comp1); "-1" : "0" : "1"; " is less than " : " is equal to " : " is greater than "); Names1 + comp2 + Names2))

3. This computed field formula for a multi-value field named Column2 compares Column1 with A and Z to see if its values start in the alphabetic range. Text is posted to Column2 when the value in Column1 is out of range.

@If(Column1 = ""; ""; @Do( Low1 := @Compare(Column1; "A"; [CASEINSENSITIVE]); High1 := @Compare(Column1; "Z"; [CASEINSENSITIVE]); Low2 := @Replace(@Text(Low1); "-1" : "0" : "1"; "Does not start with alpha" : "" : ""); High2 := @Replace(@Text(High1); "-1" : "0" : "1"; "" : "" : "Does not start with alpha"); Low2 + High2))

4. This formula retrieves all the elements that begin with a, b, or c from the text list in the sailboats field:

@For(n:=1;n <= @Elements(sailboats);n := n+1; FIELD result := @If(n=1;@If(@Compare(sailboats[n];"d";[CASEINSENSITIVE])=-1; sailboats[n];"");@If(@Compare(sailboats[n];"d";[CASEINSENSITIVE])=-1; result:(sailboats[n]);result))); result

If the sailboats field contains "Hunter":"C&C":"Pearson":"Contessa":"Bristol," this formula returns "C&C;Contessa;Bristol."

See Also

@Compare

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary