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

     

     

diecknet's avatar
diecknet
Iron Contributor
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
Jul 05, 2021

diecknet Thank you.  Your suggestion fixed the two problems I was having.  The updated script put a blank line as the first line in the output file.  The input file does not have this blank line.  The import into my program fails.  How can the blank line be prevented?

Output file

Input file

 

Resources