MongoDB $trim Operator

What You’ll Learn

The $trim operator removes leading and trailing characters from a string in MongoDB aggregation expressions. By default it strips whitespace from both sides; optionally you can specify which characters to remove.

Definition and Usage

In MongoDB’s aggregation framework, the $trim operator trims characters from both ends of a string. For example, " MongoDB " becomes "MongoDB" when you trim surrounding whitespace. This is one of the most common string-cleaning operations when working with user input, CSV imports, or legacy data that contains extra spaces.

Think of $trim as MongoDB’s pipeline version of JavaScript’s String.prototype.trim(), with an optional custom character set via the chars argument.

📝 Syntax

The $trim operator takes an object with input and an optional chars field:

{
  $trim: {
    input: <expression>,
    chars: <optional string>
  }
}

Common Patterns

// Trim leading and trailing whitespace (default)
{ $trim: { input: "$name" } }

// Trim specific characters from both ends
{ $trim: {
    input: "$code",
    chars: "*#"
}}

// Trim a literal string
{ $trim: { input: "  hello  " } }

Syntax Rules

• input — required; the string expression to trim (field reference or literal).
• chars — optional; characters to remove from both ends. If omitted, whitespace is trimmed.
• MongoDB removes matching characters repeatedly from the start and end until non-matching characters are found.
• Characters in the middle of the string are never removed.
• If input is null, the result is null.
• Use inside $project, $addFields, or $set.

Examples Gallery

Walk through a users collection with messy string fields and clean both ends with $trim.

[
  { "_id": 1, "name": "  Alice Smith  ", "email": "  alice@mail.com  " },
  { "_id": 2, "name": "\tBob Jones\t",   "email": "bob@mail.com " },
  { "_id": 3, "name": " Carol Lee ",    "email": " carol@mail.com" }
]

db.users.aggregate([
  {
    $project: {
      name: 1,
      cleanName: {
        $trim: { input: "$name" }
      }
    }
  }
])

{ "_id": 1, "name": "  Alice Smith  ", "cleanName": "Alice Smith" }
{ "_id": 2, "name": "\tBob Jones\t",   "cleanName": "Bob Jones" }
{ "_id": 3, "name": " Carol Lee ",    "cleanName": "Carol Lee" }

db.products.aggregate([
  {
    $project: {
      label: 1,
      cleanLabel: {
        $trim: {
          input: "$label",
          chars: "*"
        }
      }
    }
  }
])

// "***Premium***"  → cleanLabel: "Premium"
// "**Standard**"   → cleanLabel: "Standard"
// "*Basic*"         → cleanLabel: "Basic"

db.users.aggregate([
  {
    $addFields: {
      emailNormalized: {
        $toLower: {
          $trim: { input: "$email" }
        }
      }
    }
  }
])

db.users.aggregate([
  {
    $addFields: {
      name: {
        $trim: { input: "$name" }
      },
      email: {
        $trim: { input: "$email" }
      }
    }
  }
])

db.users.aggregate([
  {
    $project: {
      demo: {
        $trim: { input: "  MongoDB  " }
      }
    }
  }
])

// demo: "MongoDB"

db.users.aggregate([
  {
    $project: {
      original: "  MongoDB  ",
      fullTrim: {
        $trim: { input: "  MongoDB  " }
      },
      leftOnly: {
        $ltrim: { input: "  MongoDB  " }
      },
      rightOnly: {
        $rtrim: { input: "  MongoDB  " }
      }
    }
  }
])

// original:   "  MongoDB  "
// fullTrim:   "MongoDB"     ($trim both sides)
// leftOnly:   "MongoDB  "   ($ltrim start only)
// rightOnly:  "  MongoDB"   ($rtrim end only)

🚀 Use Cases

• User input cleanup — remove accidental spaces from names, emails, and form fields.
• Import normalization — fix whitespace from CSV, spreadsheet, or legacy system imports.
• Email standardization — pair with $toLower after trimming for consistent login keys.
• Consistent matching — trim before comparisons so " active " matches "active".
• Display formatting — prepare clean labels in $project for reports and APIs.

💡 Best Practices