Storing string into json object python

Question

I've read a lot of question regarding this but couldn't find any with str.

I got a long str consisting 16 bytes of name followed by 4 bytes of number and repeated for N number of people. Example as below :

*edit : 1)string is msg

2)added mike into intended output

msg = 'George\0\0\0\0\0\0\0\0\0\0' + '0095' + 'Mikeeeeeeeeeeee\0' + '0100' + 'Kelly\0\0\0\0\0\0\0\0\0\0\0' + '0000'

And now I need to store these data into json object. I've tried loop but it always rewrites the stored data before. I want something that works as below but for a lot longer string since writing msg[start:end] for every data is completely retarded.

data = {}
data[msg[0:16]] = {
    "marks" : msg[16:20]
}
data[msg[20:36]] = {
    "marks" : msg[36:40]
}
data[msg[40:56]] = {
    "marks" : msg[56:60]
}

intended output:

{
"George\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000": {
    "marks": "0095"
    }, 
"Kelly\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000": {
    "marks": "0000"
    },
 "Mikeeeeeeeeeeee\u0000": {
    "marks": "0100"
    }
}

Thanks

thats because you are making objects of every part of string instead of making it the intended nested object — warl0ck
– warl0ck, Commented May 25, 2017 at 8:36
you've posted string variable comprised of some chunks of text and then you are working with msg variable. Show the msg value — RomanPerekhrest
– RomanPerekhrest, Commented May 25, 2017 at 8:37

warl0ck · Accepted Answer · 2017-05-25 09:09:40Z

2

Assuming you want all of the object details i.e. George, mike and kelly in your data and you msg is of length 60 only while you are accessing 76 and onwards.. therefore to start appending you objects. You should make a nested json according to what you what you want as output result like:

length = len(msg)
i = 0
data = {}
while i < length:
    data[msg[i:i+16]] = {"marks" : msg[i+16:i+20]}
    i += 20
print data

Output :

{'George\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00': {'marks': '0095'}, 'Mikeeeeeeeeeeee\x00': {'marks': '0100'}, 'Kelly\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00': {'marks': '0000'}}

Hope this helps

edited May 25, 2017 at 9:09

answered May 25, 2017 at 8:46

warl0ck

3,4845 gold badges31 silver badges60 bronze badges

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

4 Comments

fieq.fikri Over a year ago

msg is sent by server hence I would never have the actual length of data. I'm hoping to get rid of the number in msg[start:end]

warl0ck Over a year ago

ok so you want dynamic creation of data object ? and is this the way you want your output to be? will the msg string length will always be in multiple of 20 since your complete parsing is based on that

fieq.fikri Over a year ago

yes. something that would ease the object creation without using 'magic number'

warl0ck Over a year ago

glad it helped :)

xrage · Accepted Answer · 2017-05-25 09:50:26Z

1

import re
dict(re.findall(r'(\D+)(\d{4})', string))

It will return response like..

{'George\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00': '0095', 'Kelly\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00': '0000', 'Mikeeeeeeeeeeee\x00': '0100'}

As you got this as dict now, This can be changed in whatever format you want.

answered May 25, 2017 at 9:50

xrage

4,8114 gold badges27 silver badges31 bronze badges

Collectives™ on Stack Overflow

Storing string into json object python

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related