That's easily done:
Get-Content c:\junk\json.txt | ConvertFrom-Json | Export-Csv c:\junk\json.csv -NoTypeInformation
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Dear Team,
Currently, I am receiving the data in the following format, which I need to convert to a CSV file. It would be helpful if you could help me convert
{“accountId”:“111111”,“resourceId”:“qqqqqqq”,“Region”:“us-east-1”}
{“accountId”:“222222”,“resourceId”:“aaaaaaa”,“Region”:“eu-central-1”}
{“accountId”:“333333”,“resourceId”:“zzzzzzz”,“Region”:“East”}
Answer accepted by question author
That's easily done:
Get-Content c:\junk\json.txt | ConvertFrom-Json | Export-Csv c:\junk\json.csv -NoTypeInformation