$rtrim - Amazon DocumentDB

本文為英文版的機器翻譯版本,如內容有任何歧義或不一致之處,概以英文版為準。

$rtrim

4.0 版的新功能。

Elastic 叢集不支援。

Amazon DocumentDB 中的$rtrim運算子用於從字串中移除結尾字元。根據預設,它會移除結尾空白字元,但您也可以透過傳遞字元引數來指定要移除的一組字元。

參數

  • input:要從中移除結尾空格字元的輸入字串。

  • chars:(選用) 移除特定字元。

範例 (MongoDB Shell)

下列範例示範如何使用 $rtrim 運算子從字串中移除結尾指定的字元 (" *")。

建立範例文件

db.collection.insert([ { "name": "John Doe* ", "age": 30 }, { "name": "Jane Smith ", "age": 25 }, { "name": "Bob Johnson", "age": 35 } ]);

查詢範例

db.collection.aggregate([ { $project: { _id: 0, name: { $rtrim: { input: "$name", chars: " *" } }, age: 1 } } ]);

輸出

[ { age: 30, name: 'John Doe' }, { age: 25, name: 'Jane Smith' }, { age: 35, name: 'Bob Johnson' } ]

程式碼範例

若要檢視使用 $rtrim命令的程式碼範例,請選擇您要使用的語言標籤:

Node.js
const { MongoClient, Bson } = require('mongodb'); async function example() { const client = await MongoClient.connect('mongodb://<username>:<password>@<cluster-endpoint>:27017/?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false'); try { const db = client.db('test'); const collection = db.collection('collection'); const pipeline = [ { $project: { _id: 0, name: { $rtrim: { input: "$name", chars: " *" } }, age: 1 } } ]; const results = await collection.aggregate(pipeline).toArray(); console.dir(results, { depth: null }); } catch (err) { console.error('Error occurred:', err); } finally { await client.close(); } } example().catch(console.error);
Python
from pymongo import MongoClient def example(): client = MongoClient('mongodb://<username>:<password>@<cluster-endpoint>:27017/?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false') try: db = client.test collection = db.collection pipeline = [ { "$project": { "_id": 0, "name": { "$rtrim": { "input": "$name", "chars": " *" } }, "age": 1 } } ] results = collection.aggregate(pipeline) for doc in results: print(doc) except Exception as e: print(f"An error occurred: {e}") finally: client.close() example()