How to organize JSON content

Question

night!

I need your help on the following question: I have 2 files . json, but when opening in Notepad++ I realize that the content is disorganized.

Example:

Arquivo1.json

{
"xxx.yyy.E-mail": "E-mail",
"xxx.yyy.Senha": "Senha",
"xxx.yyy.Voltar": "Volver",
"xxx.yyy.Enviar": "Enviar",
"xxx.yyy.Sair"  : "Sair",
}

Arquivo2.json

{
"xxx.yyy.E-mail": "E-mail",
"xxx.yyy.Voltar": "Volver",
"xxx.yyy.Senha": "Senha",
"xxx.yyy.Sair"  : "Sair",
"xxx.yyy.Enviar": "Enviar",
}

If you look at the order, it’s different! I need to sort the file 2.json to be in the same order as Arquivo1.json, taking into account that the files contain more than 3000 lines when opening in notepadd++.

Is there any way to sort the content of json ? I need to organize and then compare the contents line by line. Thanks in advance!!!

Answer 1

First I would like to suggest an edition of your Json so that the return is readable, someone can tamper with the code that one day is not you! Then I’d do something about it: Write your file using Javascript if you don’t know how to provide the link https://www.w3schools.com/js/js_json.asp

 var Json =    
{
"xxx.yyy.E-mail": "E-mail",
"xxx.yyy.Senha": "Senha",
"xxx.yyy.Voltar": "Volver",
"xxx.yyy.Enviar": "Enviar",
"xxx.yyy.Sair"  : "Sair",
 }

After that would make a very simple sorting function:

function OrdenarPorNome()
{
   Json.sort(function (a, b) { return a.Json > b.Json ? 1 : -1; });
} 

I hope I helped strong abc

Answer 2

I guess I shouldn’t be doing this, but there it is.

var arquivo_json = document.getElementById("arquivo_json");
var ordenar = document.getElementById("ordenar");
var form = document.getElementById("form");

ordenar.addEventListener("click", function (evt) {
  if (form.checkValidity())
  {
    evt.preventDefault();
    var reader = new FileReader();
    reader.addEventListener("load", function (evt) {
      var json = JSON.parse(evt.target.result);
      var novo = {};
      Object.keys(json).sort().forEach(function (key) {
        novo[key] = json[key];
      })
      var blob = new Blob(
        [JSON.stringify(novo, null, 2)], 
        { type: "application/json" }
      );
      var link = document.createElement("a");
      link.href = URL.createObjectURL(blob);
      link.download = arquivo_json.files[0].name;
      link.textContent = "download " + link.download + " ordenado";
      document.body.appendChild(link);
    });
    reader.readAsText(arquivo_json.files[0]);
  }
})

label {
line-height: 30px;
}

<form id="form" action="#">
  <label>
    Arquivo JSON: 
    <input id="arquivo_json" name="arquivo_json" required type="file" />
  </label>
  <input id="ordenar" name="ordenar" type="submit" value="Ordenar" />
</form>