I need to convert a large JSON
to CSV
, using EmEditor (Text Editor)
. I have already tried this answer and didn't work for me.
I have an error message says: Syntax error at Line 12
Could anyone look into my codes?
My json sample:
[
{
"test": "null",
"test": null,
"test": false,
"test": null,
"test": true,
"test": null,
"test": false,
"test": "null",
"test": null,
"test": null,
"test": true,
"test": true,
"test": "null",
"test": null,
"test": null,
"test": "",
"test": null,
"test": null,
"test": "null",
"test": "null",
"test": null,
"test": null,
"test": null,
"test": null,
"test": false,
"test": "null",
"test": null,
"test": null,
"test": null,
"test": null,
"test": null,
"test": null
},
{
"test": "null",
"test": null,
"test": false,
"test": null,
"test": true,
"test": null,
"test": false,
"test": "null",
"test": null,
"test": null,
"test": true,
"test": true,
"test": "null",
"test": null,
"test": null,
"test": "",
"test": null,
"test": null,
"test": "null",
"test": "null",
"test": null,
"test": null,
"test": null,
"test": null,
"test": false,
"test": "null",
"test": null,
"test": null,
"test": null,
"test": null,
"test": null,
"test": null
}
]
I'm not sure if the problem originates from my sample JSON format or the macros code.
if a python code can also do the job, is acceptable.
Thanks in advance.