Use Regex in mongodb aggregate

Question

Have a collection with values

_id:ObjectId('......')
ton_id :ObjectId('abcd')
value:qwejc+iejtns/@
date:2019-12-13T07:09:40.075+00:00


_id:ObjectId('......')
ton_id :ObjectId('abcd')
value:asdf+kine
date:2018-1-13T07:09:40.075+00:00

Need a required output :

grab data after +

_id:ObjectId('......')
ton_id :ObjectId('abcd')
value:iejtns/@
date:2019-12-13T07:09:40.075+00:00


_id:ObjectId('......')
ton_id :ObjectId('abcd')
value:kine
date:2018-1-13T07:09:40.075+00:00

Ashh · Accepted Answer · 2020-01-24 09:48:16Z

1

You can use $split to split with + sign and then $arrayElemAt to get the last index.

db.collection.aggregate([
  { "$project": {
    "value": {
      "$arrayElemAt": [{ "$split": ["$value", "+"] }, -1]
    }
  }}
])

MongoPlayground

answered Jan 24, 2020 at 9:48

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Use Regex in mongodb aggregate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related