How to replace text in split sub-string in MongoDB

Question

sample value in DB: one-two-three.js

Need to format like this: one two three

I split the field using $split aggregate, but after this how to replace "-" with " " ?

replaceAll("-", " ")

$push: {
  name: {$arrayElemAt:[{$split: ["$name" , "."]}, 0]},
}

turivishal · Accepted Answer · 2020-11-20 15:12:16Z

1

You can try,

your tried code, $set, $split name with . and get first element using $arrayElemAt
$reduce to iterate loop of name array after converting form string using $split
$concat to concat string with space and return value, this will return with extra space in first position of string, and $substr will remove that first position space

  {
    $set: {
      name: {
        $arrayElemAt: [{ $split: ["$file", "."] }, 0]
      }
    }
  },
  {
    $set: {
      name: {
        $substr: [
          {
            $reduce: {
              input: { $split: ["$name", "-"] },
              initialValue: "",
              in: { $concat: ["$$value", " ", "$$this"] }
            }
          },
          1,
          -1
        ]
      }
    }
  }

Playground

edited Nov 20, 2020 at 15:12

answered Nov 20, 2020 at 14:40

turivishal

36.4k7 gold badges48 silver badges69 bronze badges

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

2 Comments

hardcode Over a year ago

But, it doesn't split the ".js"

turivishal Over a year ago

that you have already did in your question, i have merged both in answer, you can check..

Collectives™ on Stack Overflow

How to replace text in split sub-string in MongoDB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related