Operator | Description | Example |
---|---|---|
$concat | Concatenates two or more string properties or expressions in the passed in array. | {“$concat”: [“name.first”, {“$string”: “ ”}, “name.last”]} |
$substr | Returns a portion of a string. Takes an array of three elements: source string, integer start index and integer length. The integer values can be literals, properties, or expressions. | {“$substr”: [“c_desc”, 0, 20]} |
$toLower | Returns a lowercase version of the string argument. | {“$toLower”: “c_title”} |
$toUpper | Returns an uppercase version of the string argument. | {“$toUpper”: “c_title”} |
$strcasecmp | Performs a case-insensitive string comparison. Returns 0 if the two passed in array values are equivalent, 1 if the first value is greater than the second, -1 if the second value is greater than the first. | {“$strcasecmp”: [“name.first”, {“$string”: “J”}]} |