MONGO mongodb script to replace a substring from a array element

Question

{
  field:"value",
  facilityId:"H001",
  alternativeId:["deafaultID#12312-213-1314"],
}

I want to replace all the document "defaultID" from the array of alternativeId and change to "NEWID" only if the facilityId is "H001"

you can use $replaceOne and $map operators.

turivishal
– turivishal

2021-06-07 08:03:10 +00:00
Commented Jun 7, 2021 at 8:03 — turivishal
– turivishal, Commented Jun 7, 2021 at 8:03
how.. can you give me a example

Alf joy
– Alf joy

2021-06-07 08:13:02 +00:00
Commented Jun 7, 2021 at 8:13 — Alf joy
– Alf joy, Commented Jun 7, 2021 at 8:13

turivishal · Accepted Answer · 2021-06-14 06:21:45Z

2

match facilityId: "H001" condition
$map to iterate loop of alternativeId array
$replaceOne to replace find string by replacement

db.collection.update(
  { facilityId: "H001" },
  [{
    $set: {
      alternativeId: {
        $map: {
          input: "$alternativeId",
          in: {
            $replaceOne: {
              input: "$$this",
              find: "deafaultID",
              replacement: "NEWID"
            }
          }
        }
      }
    }
  }],
  { multi: true }
)

Playground

edited Jun 14, 2021 at 6:21

answered Jun 7, 2021 at 8:16

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

3 Comments

Alf joy Over a year ago

i edited my qstn . actually i want to check facilityid as condition or filter. only replace the alternativID of a specified facilityID

turivishal Over a year ago

okay you want to update in database or just need to format result only?

turivishal Over a year ago

@Alfjoy have you checked updated answer it is working?

Collectives™ on Stack Overflow

MONGO mongodb script to replace a substring from a array element

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related