Definition定义
$ltrimRemoves whitespace characters, including null, or the specified characters from the beginning of a string.从字符串开头删除空白字符(包括null)或指定字符。$ltrimhas the following syntax:具有以下语法:{ $ltrim: { input: <string>, chars: <string> } }The$ltrimtakes a document with the following fields:$ltrim接收具有以下字段的文档:Field字段Description描述inputThe string to trim. The argument can be any valid expression that resolves to a string.要修剪的字符串。参数可以是解析为字符串的任何有效表达式。For more information on expressions, see Expressions.有关表达式的详细信息,请参阅表达式。charsOptional.可选。The character(s) to trim from the beginning of the从input.input开头开始修剪的字符。The argument can be any valid expression that resolves to a string. The参数可以是解析为字符串的任何有效表达式。$ltrimoperator breaks down the string into individual UTF code point to trim frominput.$ltrim运算符将字符串分解为单个UTF码点,以便从input中修剪。If unspecified,如果未指定,$ltrimremoves whitespace characters, including the null character.$ltrim将删除空白字符,包括空字符。For the list of whitespace characters, see Whitespace Characters.有关空白字符的列表,请参阅空白字符。
Behavior行为
By default,默认情况下,$ltrimremoves whitespace characters, including the null character, from the beginning of the input string:$ltrim会从输入字符串的开头删除空白字符,包括空字符:Example示例Results结果{ $ltrim: { input: " \n good bye \t " } }"good bye \t "You can override the default characters to trim using the您可以使用charsfield.chars字段覆盖要修剪的默认字符。For example, the following trims any例如,以下代码从输入字符串的开头修剪任何gandefrom the start of the input string. Since the input starts with a whitespace, neither character can be trimmed from the start of the string.g和e。由于输入以空格开头,因此这两个字符都不能从字符串的开头进行修剪。Example示例Results结果{ $ltrim: { input: " ggggoodbyeeeee", chars: "ge" } }" ggggoodbyeeeee"If overriding the default characters to trim, you can explicitly include the whitespace character(s) to trim in the如果覆盖要修剪的默认字符,则可以在charsfield.chars字段中明确包含要修剪的空白字符。For example, the following trims any space,例如,以下内容修剪了输入字符串开头的任何空格、g, ordfrom the start of the input string.g或d。Example示例Results结果{ $ltrim: { input: " ggggoodbyeeeee ", chars: " gd" } }"oodbyeeeee "
Whitespace Characters空白字符
By default, 默认情况下,$ltrim removes the following characters:$ltrim会删除以下字符:
| Unicode | ||
|---|---|---|
| U+0000 | '0' | Null character |
| U+0020 | ' ' | Space |
| U+0009 | 't' | Horizontal tab |
| U+000A | 'n' | Line feed/new line |
| U+000B | 'v' | Vertical tab |
| U+000C | 'f' | Form feed |
| U+000D | 'r' | Carriage return |
| U+00A0 | Non-breaking space | |
| U+1680 | Ogham space mark | |
| U+2000 | En quad | |
| U+2001 | Em quad | |
| U+2002 | En space | |
| U+2003 | Em space | |
| U+2004 | Three-per-em space | |
| U+2005 | Four-per-em space | |
| U+2006 | Six-per-em space | |
| U+2007 | Figure space | |
| U+2008 | Punctuation space | |
| U+2009 | Thin space | |
| U+200A | Hair space |
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 以下操作使用$ltrim operator to remove leading whitespaces from the description field:$ltrim运算符从description字段中删除前导空格:
db.inventory.aggregate([
{ $project: { item: 1, description: { $ltrim: { 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. \n\n " }
{ _id: 3, item: "XYZ1", description: null }