Issue in reading a text file contains dict data

[bharathappriyan]

Hi,
I am new to python. I have a text file contains data in below format.
{"ts": "2018-09-10 10:20:11.312151","action":0,"type":0,"Query":"SELECT COL1,COL2\n FROM TABLE1\LIMIT 1","ID":2}
{"ts": "2018-09-10 10:20:11.312151","action":"","type":0,"Query":"","ID":2} like that.
Expected Output:
key1 key2 key3 key4 ...
val1 val2 val3 ...
val1 val2 val3 ...

How do I read the file and parse the data?

Thanks.

[buran]

Is every dict on a different line? No commas between? is the example correct, e.g. TABLE1\LIMIT I think should be TABLE1\nLIMIT?
I would go to read each line and parse it as json string.then use csv module to write to csv file.

[bharathappriyan]

Yes. Every dictionary is in different line. And TABLE\n LIMIT is the correct one. what is the code should I use?

Thanks.

[buran]

read each line and parse it as json string.then use csv module to write to csv file.

try to write a code and post it here if you have problem

[Larz60+]

Is this verbatim:

{"ts": "2018-09-10 10:20:11.312151","action":0,"type":0,"Query":"SELECT COL1,COL2\n FROM TABLE1\LIMIT 1","ID":2}
{"ts": "2018-09-10 10:20:11.312151","action":"","type":0,"Query":"","ID":2} like that

because if above is encased in brackets '[]', it's probably a JSON file.
and can easily be loaded into a dictionary with json.load