Forum Discussion

JoyriderBC's avatar
JoyriderBC
Copper Contributor
Jun 18, 2021
Solved

Powershell is corrupting comma delimited files

My PowerShell script is adding double quotes and formatting the text incorrectly.  I am removing lines that have a particular string. This line created by PowerShell script "RECTYPE,CNTBTCH,CNTITEM...
Windows PowerShell
  • diecknet's avatar
    diecknet
    Jun 28, 2021

    JoyriderBC You can specify the encoding of the files with the -Encoding parameter.

     

    For example:

     

    Out-File c:\Exports\'Receiving Export SAGE Zeroes Gone.CSV' -Encoding utf8

     

     

JoyriderBC's avatar
JoyriderBC
Copper Contributor
Jun 24, 2021

farismalaeb The double quotes are minor problem.  It is the record corruption.  See the HEX dump where after every character there are unprintable codes.

farismalaeb's avatar
farismalaeb
Iron Contributor
Jun 28, 2021
Can you share part of the output file, just put dump data in it and let me have a closer look.
Thanks

Resources