使用PowerShell将CSV转换为JSON [英] Convert CSV to JSON using PowerShell
问题描述
我需要将CSV文件(下面的示例CSV)中的数据转换为JSON:
I have a requirement to convert data in a CSV file (sample CSV below) into JSON:
电子邮件,FName,LName,位置
Joe.bloggs @ abc.co.uk,Joe,Bloggs,London
Jack.smith @ abc.co.uk,Jack,Smith,格拉斯哥
Jackie.smith @ abc.co.uk,Jackie,Smith,Manchester
Email,FName,LName,Location
Joe.bloggs@abc.co.uk,Joe,Bloggs,London
Jack.smith@abc.co.uk,Jack,Smith,Glasgow
Jackie.smith@abc.co.uk,Jackie,Smith,Manchester
我正在使用以下代码:
Get-Content -path $inputFeederFile | ConvertFrom-Csv -Delimiter ',' | ConvertTo-Json | Out-File $outputFile
这将产生以下JSON:
This produces the following JSON:
[
{
电子邮件": " Joe.bloggs@abc.co.uk ",
" FName": " Joe" ;,
" LName": 博客",
位置": 伦敦"
},
{
电子邮件": " Jack.smith@abc.co.uk ",
" FName": "Jack",
" LName": "Smith",
位置": 格拉斯哥"
},
{
电子邮件": " Jackie.smith@abc.co.uk ",
" FName": "Jackie",
" LName": "Smith",
位置": 曼彻斯特"
}
]
[
{
"Email": "Joe.bloggs@abc.co.uk",
"FName": "Joe",
"LName": "Bloggs",
"Location": "London"
},
{
"Email": "Jack.smith@abc.co.uk",
"FName": "Jack",
"LName": "Smith",
"Location": "Glasgow"
},
{
"Email": "Jackie.smith@abc.co.uk",
"FName": "Jackie",
"LName": "Smith",
"Location": "Manchester"
}
]
但是我所需的格式是:
{
值":[
{
电子邮件": " Joe.bloggs@abc.co.uk ",
" FName": " Joe" ;,
" LName": 博客",
位置": 伦敦"
},
{
电子邮件": " Jack.smith@abc.co.uk ",
" FName": "Jack",
" LName": "Smith",
位置": 格拉斯哥"
},
{
电子邮件": " Jackie.smith@abc.co.uk ",
" FName": "Jackie",
" LName": "Smith",
位置": 曼彻斯特"
}
]
}
{
"value": [
{
"Email": "Joe.bloggs@abc.co.uk",
"FName": "Joe",
"LName": "Bloggs",
"Location": "London"
},
{
"Email": "Jack.smith@abc.co.uk",
"FName": "Jack",
"LName": "Smith",
"Location": "Glasgow"
},
{
"Email": "Jackie.smith@abc.co.uk",
"FName": "Jackie",
"LName": "Smith",
"Location": "Manchester"
}
]
}
如何添加值:"使用代码阻止?我想避免手动编辑?
How can i add "value:" block using code? I wanted to avoid manual editing?
此致
推荐答案
您好,Kashif,
Hi Kashif,
你在这里
https://stackoverflow.com/questions/30723577/convert-csv-to-json-and-json-to-csv-using-powershell
https://stackoverflow.com/questions/30723577/convert-csv-to-json-and-json-to-csv-using-powershell
这篇关于使用PowerShell将CSV转换为JSON的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!