locked
Get-FolderItem how to export csv using UTF-8 RRS feed

  • General discussion

  • Hi everyone,

    Found this great script at the repository https://gallery.technet.microsoft.com/Get-Deeply-Nested-Files-a2148fd7

    However, having issues with some characters in Portuguese and Spanish, like á, ó, ç, and others. The exported CSV shows those characters as blank spaces or the E as in the Euro currency.

    Using like this: Get-FolderItem -path "path" | export-csv -NoTypeInformation -Encoding UTF8 c:\filename.csv

    When using "-Encoding UTF8" some characters appear in blank while others appear as € or ‡;

    If I remove the "-Encoding UTF8" those special characters appears as "?" and the file is encoded as ANSI.

    Get-ChildItem exports fine when using UTF8 but we stops at the 260 characters limit at the file path.

    Any idea how to get the file correctly encoded?

    • Changed type Bill_Stewart Monday, July 11, 2016 2:44 PM
    • Moved by Bill_Stewart Monday, July 11, 2016 2:44 PM This is not support forum for gallery scripts
    Wednesday, June 1, 2016 9:31 PM

All replies