How can I extract key value pair in a table?

[siddharthmis]

I have data like
Data: {"code": "abc", "version": "2018.6", "name": "testdata", "group": "QA", "DB": "oracle"}
in the field Message.
How can I export the key and value pair in a table.
So, I would need code, version, name, group, Db in a table.

I tried using spath but it didn't work as the data is not exactly in json format.
How can I get the data in tabular format.

[kthammireddygar · Accepted solution]

Hope this helps

index=foo sourcetype=xyz ... | extract pairdelim="{,}" kvdelim=":" | table code version name group DB

[siddharthmis]

It helps, thanks!