split json file into object per file

Question

I have a JSON file, with a structure like this:

{
"106" : {
      "id54011" : [
         {
            "partno1" : "16690617"
         },
         {
            "partno2" : "5899180"
         }
      ],
      "parts" : [
         "0899180",
         "16920617"
      ],
      "id5632" : [
         {
            "partno1" : "090699180"
         }
      ]
   },
   "560" : {
      "id9452" : [
         {
            "partno2" : "1569855"
         }
      ],
      "parts" : [
         "03653624",
         "15899855"
      ],
      "id578" : [
         {
            "partno3" : "0366393624"
         },
         {
            "partno4" : "0363213624"
         }
      ]
   }
}

I need to split this JSON into multiple files, using this method:

Each JSON file will consist of one object. Using the example file above, I should end up with 000106.json, and 000560.json. (All names, must have 6 digits, so zeros must be added.)

I have tried to use an iteration grouper, in python, and jq, for this, but no luck up to now.

Expected output: JSON file 1, named 000106.json:

{
   "106" : {
       "id54011" : [
           {
               "partno1" : "16690617"
           },
           {
               "partno2" : "5899180"
           }
       ],
       "parts" : [
           "0899180",
           "16920617"
       ],
       "id5632" : [
           {
               "partno1" : "090699180"
           }
       ]
   }
}

JSON file 2, named 000560.json:

{
    "560" : {
        "id9452" : [
            {
                "partno2" : "1569855"
            }
        ],
        "parts" : [
            "03653624",
            "15899855"
        ],
        "id578" : [
            {
                "partno3" : "0366393624"
            },
            {
                "partno4" : "0363213624"
            }
        ]
    }
}

What is your expected output ?

VIPIN KUMAR
– VIPIN KUMAR

2017-03-10 11:18:07 +00:00
Commented Mar 10, 2017 at 11:18 — VIPIN KUMAR
– VIPIN KUMAR, Commented Mar 10, 2017 at 11:18
Possible duplicate of Parsing JSON with Unix tools

miken32
– miken32

2017-03-10 17:48:45 +00:00
Commented Mar 10, 2017 at 17:48 — miken32
– miken32, Commented Mar 10, 2017 at 17:48

Community · Accepted Answer · 2017-05-23 11:54:19Z

0

Since this question has both jq and awk tags, I'd recoomend using jq and awk as explained here: Split a JSON file into separate files

You can easily pad the key names in jq or awk.

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Apr 4, 2017 at 14:33

peak

119k21 gold badges185 silver badges218 bronze badges

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

Collectives™ on Stack Overflow

split json file into object per file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related