how to remove tag @{} in power shell

Question

I want to displaying data from json to env file with this output

OnSubscription=True; Name=John; Surname=Smith

but when I create data, its showing like this

@{OnSubscription=True; Name=John; Surname=Smith}

and this is my script

$Path2 = ".\output\env"
$x = Get-Content .\basket.json| ConvertFrom-Json

foreach( $rootProperty in @($x.psobject.properties | where-object {$_.MemberType -eq "NoteProperty"}) )
{

    write-host "'$($rootProperty.Name)' = '$($rootProperty.Value)'"

    foreach( $childProperty in @($rootProperty.Value.psobject.properties | where-object {$_.MemberType -eq "NoteProperty"}) )
    {
        write-host "'$($childProperty.Name)' = '$($childProperty.Value)'"
         
        
    }

    $result = Add-Content -Path  $Path2 "$($rootProperty.Value) "

    $result = Add-Content -Path  $Path2 "$($childProperty.Value) " 

}

This is my sample of json

{
    "Customer":  {
                     "OnSubscription":  true,
                     "Name":  "John",
                     "Surname":  "Smith"
                 },
    "Data":  {
                 "Basket":  [
                                "apples",
                                "pears",
                                "oranges",
                                "strawberries"
                            ]
             }
}

How to remove this @{} ? I already follow this example Create .env file from a .json file but with power shell

When you say that your output should be `OnSubscription=True; Name=John; Surname=Smith` do you mean that literal or the semicolons are meant to be new lines? Also your way of exporting data doesn't make much sense. — Santiago Squarzon, Jun 21 '21 at 05:59
yes the output should be OnSubscription=True; Name=John; Surname=Smith on env file. My problem only the output using @{ } — Blanc Chen, Jun 21 '21 at 06:00

Santiago Squarzon · Accepted Answer · 2021-06-21T12:54:03.830

3

Try this:

$json = @'
{
    "Customer": {
        "OnSubscription":  true,
        "Name":  "John",
        "Surname":  "Smith"
    },
    "Data": {
        "Basket": [
            "apples",
            "pears",
            "oranges",
            "strawberries"
        ]
    }
}
'@ | ConvertFrom-Json

$output = ($json.Customer.PSObject.Properties.Name | ForEach-Object {
    "$_={0}" -f $json.Customer.$_
}) -join '; '

$Path2 = ".\output\env"
$output | Out-File $path

From File:

$json = Get-Content .\basket.json -Raw | ConvertFrom-Json
$output = ($json.Customer.PSObject.Properties.Name | ForEach-Object {
    "$_={0}" -f $json.Customer.$_
}) -join '; '

$Path2 = ".\output\env"
$output | Out-File $path

edited Jun 21 '21 at 12:54

answered Jun 21 '21 at 06:13

Santiago Squarzon

41,465
5
14
37

but is this working without json hard code? i mean from basket.json directly – Blanc Chen Jun 21 '21 at 06:29
@BlancChen yes it should, but will only work with the ***Customer*** property. – Santiago Squarzon Jun 21 '21 at 12:54

how to remove tag @{} in power shell

1 Answers1