$split and return the first array element in mongodb query

Question

[
  {lecture : "427#Math"},
  {lecture : "217#Science"},
  {lecture : "7#History"},
  {lecture : "12#Music"}
]

Assume I have the database structure above. I want to return only the lecture code. What have I done so far?

db.collection.aggregate([
    {$project: {"lecture": {$split: ["$lecture" , "#"]}}}
])

But this returns as collection ["427" , "Math"]. How can I return only the lecture code which is the part that comes before the # character.

Alex Blex · Accepted Answer · 2017-04-25 09:05:44Z

24

You can use $arrayElemAt to return only first item from $split result:

db.collection.aggregate([
    {$project: {"lecture": {$arrayElemAt:[{$split: ["$lecture" , "#"]}, 0]}}}
])

answered Apr 25, 2017 at 9:05

Alex Blex

37.3k7 gold badges53 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1