Rule operator details and examples

The following pages describe each operator in greater detail. Each Rule Operator has the following sections

1. Syntax – Describes the standard syntax used with this operator. In this section, as in the previous summary tables, the angle bracket convention <..> is used to indicate what types of terms and their data types can be used with the operator. When using the operator with real terms from the Vocabulary, do not include the angle brackets.
2. Description – Provides a plain-language description of the operator's purpose and details of its use. Important reminders, tips, or cautions are included in this section.
3. Usage Restrictions – Describes what limitations exist for this operator, and where an operator may not be used in a Rulesheet. Such limitations are rare, but important to a good understanding of Corticon Studio.
4. Example – Shows an example of each operator in a Rulesheet. A screenshot of the example Rulesheet is provided, with portions of the Rulesheet not used by the example collapsed or truncated for clarity. The example also includes sample input and output data for Ruletest scenarios run against the Rulesheet.

The entire list of operators is presented in alphabetic order.

Contents

1. Absolute value

2. Add numbers

3. Add strings

4. Add days

5. Add hours

6. Add minutes

7. Add months

8. Add seconds

9. Add years

10. Associate elements

11. At

12. Average

13. CellValue

14. Character at

15. Clone

16. Concatenate

17. Contains

18. Day

19. Day of week

20. Day of year

21. Days between

22. Decrement

23. Disassociate elements

24. Divide

25. Div

26. Ends with

27. Equals ignoring case

28. Equals when used as an assignment

29. Equals when used as a comparison

30. Equals when using Strings

31. Exists

32. Exponent

33. False

34. First

35. First NUMBER

36. Floor

37. For all

38. Get Milliseconds

39. Greater than

40. Greater than or equal to

41. Hour

42. Hours between

43. In LIST

44. In RANGE

45. Increment

46. Index of

47. Is empty

48. Is integer

49. Iterate

50. Last

51. Last NUMBER

52. Less than

53. Less than or equal to

54. Logarithm BASE 10

55. Logarithm BASE X

56. Lowercase

57. Matches

58. Maximum value

59. Maximum value COLLECTION

60. Minimum value

61. Minimum value COLLECTION

62. Minute

63. Minutes between

64. Mod

65. Month

66. Months between

67. Multiply

68. Natural logarithm

69. New

70. New unique

71. Not

72. Not empty

73. Not equal to

74. Now

75. Null

76. Other

77. Or

78. Random

79. Regular expression to replace String

80. Remove element

81. Replace elements

82. Replace String

83. Round

84. Second

85. Seconds between

86. Size of collection

87. Size of string

88. Sorted by

89. Sorted by descending

90. Starts with

91. SubSequence

92. Substring

93. Subtract

94. Sum

95. Today

96. To date Casting a dateTime to a date

97. To dateTime Casting a date to a dateTime

98. To dateTime Casting a string to a dateTime

99. To dateTime Casting a time to a dateTime

100. To dateTime Timezone offset

101. To decimal

102. To integer

103. To string

104. To time Casting a dateTime to a time

105. Trend

106. Trim spaces

107. True

108. Uppercase

109. Week of month

110. Week of year

111. Year

112. Years between