[char]0xFFFF breaking export

[nlangsto]

Hello

I had this issue:

Turns out I had to remove the unicode character so that exporting the excel would work

$alldata | % {$.Status = -join ($.Status.ToCharArray() | Where-Object { $_ -ne [char]0xFFFF })}

Thanks
Neil

[nlangsto]

Here is the data, funny, it also breaks
| Export-Clixml
&
| ConvertTo-Json -depth 10 | Out-File
too
corruptdatafile.zip

so the attached is an
| Out-File

[dfinke]

Thanks for the info @nlangsto and using ImportExcel.

I was wondering if it caused issues elsewhere.

Not sure of a general solutin off the top of my head.

[YeharaDananjaya]

maybe this solution will solve your problem click