Articles → MONGODB → $Substrcp Aggregation Function In Mongodb

$Substrcp Aggregation Function In Mongodb

In this article, we will discuss the $substrCP aggregation function in MongoDB.

Purpose

The $substrCP aggregation function is used to return the substring from the string.

{ $substrCP: [ <string>, <start>, <length> ] }

Consider the following example: -

To find the substring, we will use the following query: -

db.Employees.aggregate([
  {
    $project: {      
      name: { $substrCP: ["$firstname", 0, 2] }
    }
  }
])

Query/Feedback