Json Encoding HTML string

Question

I'm currently producing a JSON file from a PowerShell script but it is outputting Unicode instead of special characters such as '<' I need HTML in the LinkText but not sure how to change the encoding.

This is the output I'm getting:

[
    {
        "Id":  "187303",
        "LinkText":  "\u003cb style =color:#d11717;\u0027\u003eAnnual General Meeting (MEET)"
    },
    {
        "Id":  "187305",
        "LinkText":  "\u003cb style =color:#d11717;\u0027\u003eAnnual General Meeting (MEET)"
    }
]

This is the code that I'm using:

$(foreach ($row in $DataSet.Tables[0].Rows){  
    $stockShortName = $row[0].ToString().Trim()
    $id = $row[0].ToString().Trim()
    $linkText = "<b style =color:`#d11717;'>$event_description" 

    (New-Object PSObject |
     Add-Member -PassThru NoteProperty Id $id |
     Add-Member -PassThru NoteProperty LinkText $linkText 
    )
}) | ConvertTo-JSON | Out-File $OutputFile -Encoding "default"

Shay Levy · Accepted Answer · 2013-03-23 12:16:42Z

up vote 0 down vote accepted

I don't see a built-in parameter to prevent that conversion from happening. Here's a workaround that converts back unicode characters:

[regex]::replace($json,'\\u[a-fA-F0-9]{4}',{[char]::ConvertFromUtf32(($args[0].Value -replace '\\u','0x'))})

answered Mar 23 at 12:16

Shay Levy
27.8k21639

Thanks for this Shay – steven Mar 25 at 11:28

takiysobi · Answer 2 · 2013-03-22 19:53:26Z

up vote 0 down vote

Out-File is not a culprit here, it writes exactly what ConverTo-Json produces. However, if you pipe your output into ConvertFrom-Json, it works just fine. Are you sure it's a problem?

answered Mar 22 at 19:53

takiysobi
213

asked	2 months ago
viewed	100 times
active	2 months ago

Json Encoding HTML string

2 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged json powershell powershell-v3.0 or ask your own question.

Community Bulletin

Json Encoding HTML string

2 Answers

Your Answer

Sign up or log in

Post as a guest

Not the answer you're looking for? Browse other questions tagged json powershell powershell-v3.0 or ask your own question.

Community Bulletin

Related