$rtrim (aggregation)（聚合）

Definition定义

$rtrim

Removes whitespace characters, including null, or the specified characters from the end of a string.从字符串末尾删除空白字符（包括null）或指定字符。

$rtrim has the following syntax:具有以下语法：

{ $rtrim: { input: <string>,  chars: <string> } }

The $rtrim takes a document with the following fields:$rtrim接收一个包含以下字段的文档：

Field字段	Description描述
input	The string to trim. The argument can be any valid expression that resolves to a string. 要修剪的绳子。参数可以是解析为字符串的任何有效表达式。For more information on expressions, see Expressions.有关表达式的详细信息，请参阅表达式。
chars	Optional. 可选。The character(s) to trim from the end of the input.从input末尾开始修剪的字符。 The argument can be any valid expression that resolves to a string. 参数可以是解析为字符串的任何有效表达式。The $rtrim operator breaks down the string into individual UTF code point to trim from input.$rtrim运算符将字符串分解为单独的UTF码点，以便从input中修剪。 If unspecified, $rtrim removes whitespace characters, including the null character. 如果未指定，$rtrim将删除空白字符，包括空字符。For the list of whitespace characters, see Whitespace Characters.有关空白字符的列表，请参阅空白字符。

Tip

• $ltrim
• $trim

Behavior行为

• By default, $rtrim removes whitespace, including the null character, from the end of the input string:默认情况下，$rtrim会从输入字符串末尾删除空格，包括空字符：

  Example示例	Results结果
  { $rtrim: { input: " \n good bye \t " } }	" \n good bye"

• You can override the default characters to trim using the chars field.您可以使用chars字段覆盖要修剪的默认字符。

  For example, the following trims any g and e from the end of the input string. Since the input ends with a whitespace, neither character can be trimmed from the end of the string.例如，以下代码从输入字符串末尾修剪任何g和e。由于输入以空格结尾，因此这两个字符都不能从字符串末尾修剪。

  Example示例	Results结果
  { $rtrim: { input: "ggggoodbyeeeee ", chars: "ge" } }	"ggggoodbyeeeee "

• If overriding the default characters to trim, you can explicitly include the whitespace character(s) to trim in the chars field.如果覆盖要修剪的默认字符，则可以在chars字段中明确包含要修剪的空白字符。

  For example, the following trims any space or e from the end of the input string.例如，以下内容修剪了输入字符串末尾的任何空格或e。

  Example示例	Results结果
  { $rtrim: { input: " ggggoodbyeeeee ", chars: "e " } }	" ggggoodby"

Example示例

Consider an inventory collection with the following documents:考虑使用以下文件进行inventory集合：

db.inventory.insertMany( [
   { _id: 1, item: "ABC1", quarter: "13Q1", description: " product 1" },
   { _id: 2, item: "ABC2", quarter: "13Q4", description: "product 2 \n The product is in stock.  \n\n  " },
   { _id: 3, item: "XYZ1", quarter: "14Q2", description: null }
] )

The following operation uses the $rtrim operator to remove trailing whitespace from the description field:以下操作使用$rtrim运算符从description字段中删除尾随空格：

db.inventory.aggregate([
   { $project: { item: 1, description: { $rtrim: { input: "$description" } } } }
])

The operation returns the following results:该操作返回以下结果：

{ _id: 1, item: "ABC1", description: " product 1" }
{ _id: 2, item: "ABC2", description: "product 2 \n The product is in stock." }
{ _id: 3, item: "XYZ1", description: null }