$ltrim (聚合)
定义
行为
默认情况下,
$ltrim
从输入字符串的开始删除空白字符,包括空字符示例结果{ $ltrim: { input: " \n good bye \t " } }
"good bye \t "
您可以使用
chars
字段覆盖默认的修剪字符。例如,以下从输入字符串的开始修剪任何
g
和e
。由于输入以空白字符开始,因此无法从字符串的开始修剪这两个字符。示例结果{ $ltrim: { input: " ggggoodbyeeeee", chars: "ge" } }
" ggggoodbyeeeee"
如果要覆盖默认的修剪字符,可以在
chars
字段中显式地包含要修剪的空白字符。例如,以下示例从输入字符串的开始处修剪任何空格、
g
或d
。示例结果{ $ltrim: { input: " ggggoodbyeeeee ", chars: " gd" } }
"oodbyeeeee "
空白字符
默认情况下,$ltrim
修剪以下字符
Unicode | 转义序列 | 描述 |
---|---|---|
U+0000 | '0' | 空字符 |
U+0020 | ' ' | 空格 |
U+0009 | 't' | 水平制表符 |
U+000A | 'n' | 换行符/新行 |
U+000B | 'v' | 垂直制表符 |
U+000C | 'f' | 换页符 |
U+000D | 'r' | 回车符 |
U+00A0 | 非断行空格 | |
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 |
示例
考虑一个具有以下文档的 inventory
集合
{ "_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 }
以下操作使用 $ltrim
操作符从 description
字段中删除前导空白字符
db.inventory.aggregate([ { $project: { item: 1, description: { $ltrim: { input: "$description" } } } } ])
操作返回以下结果
{ "_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 }