Question 239821 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Remove dot inside a number

I have the following JSON type file:

[{ "sid": "s-mtl-1", "MaterialNumber": "0.4440", "MaterialWNumber": "W0.4440", "tubePrice": "12"},
{ "sid": "s-mtl-2",  "MaterialNumber": "0.5550", "MaterialWNumber": "W0.5550", "tubePrice": "13"},
{ "sid": "s-mtl-3",  "MaterialNumber": "0.6660", "MaterialWNumber": "W0.6660", "tubePrice": "14"}]

And I would like to remove the dot in "MaterialWNumber" values, to have it like this:

[{ "sid": "s-mtl-1", "MaterialNumber": "0.4440", "MaterialWNumber": "W04440", "tubePrice": "12"},
{ "sid": "s-mtl-2",  "MaterialNumber": "0.5550", "MaterialWNumber": "W05550", "tubePrice": "13"},
{ "sid": "s-mtl-3",  "MaterialNumber": "0.6660", "MaterialWNumber": "W06660", "tubePrice": "14"}]

Anyone has an idea how to do this? I can’t find a way to locate the value of "MaterialWNumber" and remove/change a character, which is inside a number/word to keep the original values.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    As @svlasov commented, the task can be done in VIM editor as: %s/(Wd+).(d+)/12. Or in VS code neovim: %s/(Wd+).(d+)/12.


Please signup or login to give your own answer.

Back To Top
Search