MongoDB $indexOfCP

In MongoDB, the $indexOfCP aggregation pipeline operator searches a string for an occurrence of a substring and returns the UTF code point index of the first occurrence.

The UTF code point index is zero-based (i.e. it starts at 0).

Read more

MongoDB $indexOfBytes

In MongoDB, the $indexOfBytes aggregation pipeline operator searches a string for an occurrence of a substring and returns the UTF-8 byte index of the first occurrence.

The UTF byte index is zero-based (i.e. it starts at 0).

Read more

MongoDB $trunc

In MongoDB, the $trunc aggregation pipeline operator truncates a number to a whole integer or to a specified decimal place.

You have the option of specifying how many decimal places for which to truncate the number. To do this, pass a second argument. The first argument is the number to truncate, and the second (optional) argument is the number of decimal places to truncate it to.

Omitting the second argument truncates all digits to the right of the decimal and returns the whole integer value.

Read more