convert 1 dimension strings array into json file

Question

Perhaps it's easy question and will be banned but I spend hours today and not make it work as I expected. so I have such object:

data_1 data_2 ... abra_12 ...

I want convert it into json like this:

[
    {"data_1" : "data_1"},
    {"data_2" : "data_2"},
    ...
]

I tried this:

$result = Get-ChildItem $Path2Search -recurse | Select-String -Pattern '(?<=locI(.*)\(\").+?(?=\")' -casesensitive | foreach {$_.matches} | select value | ConvertTo-Json | Out-File $save2file

But I'm getting this:

{
   "Value":  "data_1"
},
{
   "Value":  "data_2"
},

While I want it like this:

{
   "data_1":  "data_1"
},
{
   "data_2":  "data_2"
},

Any advice how? :)

Reza Aghaei · Accepted Answer · 2017-12-17 12:30:32Z

3

You can first shape the result in a list of key-values then convert it to json.

For example if your input is a comma separated string, you can use:

$input = "data_1, data_2, data_3"
$input.Split(',').Trim() | 
    ForEach-Object {@{$_=$_}} | 
        ConvertTo-Json | 
             Out-File "C:\test.txt"

Or if the input is a string array:

$input = @("data_1", "data_2", "data_3")
$input | ForEach-Object {@{$_=$_}} | 
        ConvertTo-Json |
            Out-File "C:\test.txt"

And the result would be:

[
    {
        "data_1":  "data_1"
    },
    {
        "data_2":  "data_2"
    },
    {
        "data_3":  "data_3"
    }
]

While I prefer to use above solution for creating json result, but you also can rely on string manipulation as well:

$input = "data_1, data_2, data_3"
@"
[ 
`t$(($input -split '\s*,\s*' |%{"{ `"$_`" : `"$_`" }"}) -join ",`n`t")
]
"@

edited Dec 17, 2017 at 12:30

answered Dec 11, 2017 at 6:10

Reza Aghaei

126k18 gold badges239 silver badges447 bronze badges

Sign up to request clarification or add additional context in comments.

16 Comments

Gorodeckij Dimitrij Over a year ago

thanks, but in my case they are not comma separated, exactly data feeding from this line of code: $result = Get-ChildItem $Path2Search -recurse | Select-String -Pattern '(?<=locI(.*)\(\").+?(?=\")' -casesensitive | foreach {$_.matches} | select value any advice how to split it then?

Reza Aghaei Over a year ago

Just put the array instead of $input.Split(',').Trim()

Gorodeckij Dimitrij Over a year ago

just put instead of not work, drop error: ConvertTo-Json : The type 'System.Collections.Hashtable' is not supported for serialization or deserialization of a dictionary. Keys must be strings

Gorodeckij Dimitrij Over a year ago

I make it work like this: ...foreach {$_.matches} | ForEach-Object -begin {$result = "{"} -process {$result = $result+$_.Value+":"+$_.Value+","} -end {$result = $result+"}"} $result | Out-File $output but that dont look like nice :/

Reza Aghaei Over a year ago

How is it related to the code which I shared with you?!

|

Collectives™ on Stack Overflow

convert 1 dimension strings array into json file

1 Answer 1

16 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

16 Comments

Your Answer

Sign up or log in

Post as a guest

Related