How to convert string to a list of json in python?

Question

I have a string in the form of [[sourceId:111, clientId:12345, clientName:testclient, module:test,source:Request, userName:Michelle Jackson],[sourceId:112, clientId:1233, clientName:testclient2, module:test, source:Request, userName:Michelle Jackson]]

How do I convert it into a valid python list of json ?

The problem is from where the string is generated. That is not a proper JSON format. If you have control over the source then fix it at source. — Vishnudev Krishnadas
– Vishnudev Krishnadas, Commented Nov 28, 2020 at 5:22
First,you shoud convert your data to dict style,just like: [[{'sourceId':111},{'clientId':12345},{'clientName':'testclient'},{'module':'test'},{'source':'Request'},{'userName':'Michelle Jackson'}], [{'sourceId':112},{'clientId':1233},{'clientName':'testclient2'}, {'module':'test',{'source':'Request'},{'userName':'Michelle Jackson'}]] Your current data format has a syntax error in the list. — user9270170
– user9270170, Commented Nov 28, 2020 at 5:42

Vishnudev Krishnadas · Accepted Answer · 2020-11-28 05:45:27Z

1

Although I never recommend doing this, here's the code

import re
arr = []
for x in s.split('],['):
    kv = re.sub('\[|\]', '', x)
    arr.append(dict(kvi.split(':') for kvi in kv.split(',')))

NOTE: If the string is system generated, it's better to get it in JSON format in the first place.

edited Nov 28, 2020 at 5:45

answered Nov 28, 2020 at 5:37

Vishnudev Krishnadas

11k2 gold badges29 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

How to convert string to a list of json in python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related