node.js search and replace an exact string in json output using variables

Question

I have found a LOT of posts that show how to do a search and replace for an exact string between quotes when using a wild card or direct search string. However when using variables in a for loop I am having trouble getting the correct syntax.

I have a number of keys in a json output from a db,

myJson = JSON.stringify(rowsMap);

gives

{
  "myStuff": [
    {
      "abc": "val_de_1",
      "abcxz": "val_xc_1",
      "mnabc": "val_abc_1"
    },
    {
      "abc": "val_de_2",
      "abcxz": "val_xc_2",
      "mnabc": "val_abc_2"
    },
    {
      "abc": "val_de_3",
      "abcxz": "val_xc_3",
      "mnabc": "val_abc_3"
    }
}

Now I would like to loop over the JSON and replace some of the key strings using a 2nd k:v pair

 for (var myVal in myPairs) {
        myJson = myJson.replace(RegExp(myVal, "g"), myPairs[myVal]);
        ....
        }

Now if the values are abc to 777 I get the following,

{
      "myStuff": [
        {
          "777": "val_de_1",
          "777xz": "val_xc_1",
          "mn777": "val_777_1"
        },
        {
          "777": "val_de_2",
          "777xz": "val_xc_2",
          "mn777": "val_777_2"
        },
        {
          "777": "val_de_3",
          "777xz": "val_xc_3",
          "777bc": "val_777_3"
        }
}

but I actually want

{
      "myStuff": [
        {
          "777": "val_de_1",
          "abcxz": "val_xc_1",
          "mnabc": "val_abc_1"
        },
        {
          "777": "val_de_2",
          "abcxz": "val_xc_2",
          "mnabc": "val_abc_2"
        },
        {
          "777": "val_de_3",
          "abcxz": "val_xc_3",
          "mnabc": "val_abc_3"
        }
    }

I have seen the use of brackets braces and variations of quotes before and after a literal string but not a variable.

What is the most efficient method for processing? I have been able to do it in a cluncky manner

for (var myVal in myPairs) {

            myNewVal = "\""+myVal+"\"";
            myNewRep = "\""+myPairs[myVal]+"\"";
            myJson = myJson.replace(RegExp(myNewVal, "g"), myNewRep);
            ....
            }

Note I am looking for a solution where the regexp must look for the exact string between quotes, not include the quotes. The idea is to only do the myNewRep if the string is found, thereby making it faster I assume.

Sridhar · Accepted Answer · 2017-08-14 18:45:02Z

4

You can replace the json key string with /[abc]/g

This will replace the exact string.

some matches I tried.

abc - match "abc" - match abcd - Not match

http://www.regexpal.com/ - try this to test.

answered Aug 14, 2017 at 18:45

Sridhar

2311 silver badge8 bronze badges

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

Comments

Tobiq · Accepted Answer · 2017-08-14 18:45:09Z

0

You could split the string by quotes

'"abc"'.match(/"(.*?)"/)

edited Aug 14, 2017 at 18:45

answered Aug 14, 2017 at 18:27

Tobiq

2,6972 gold badges24 silver badges48 bronze badges

1 Comment

art vanderlay Over a year ago

this does not work with a variable as per the question. the regexp must look for the exact string between quotes, not include the quotes.

Collectives™ on Stack Overflow

node.js search and replace an exact string in json output using variables

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related