locked
Unable to do export-csv from an empty .txt file RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Team,
        
    I am trying to create a csv file from an empty text file.The csv file should get created with only headers as no data present in text file but my code is creating a complete blank csv file without header.Anything missing in below code ?

     

         
     import-csv -Path "C:\Powershell-Work\EmtyTest.txt" -Header Date,Time,'R Site',Status,Comments |
Select-Object 'Process Date',Date,Time,'R Site',Status,Comments| 
Export-csv -path "C:\Powershell-Work\EmtyTest.csv" -NoTypeInformation

    Thursday, April 5, 2018 6:27 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    What do you really want to achieve?

    Your logic makes no sense in my opinion.

    Thursday, April 5, 2018 6:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Close but ...

    Try this:

    '' | Select-Object 'Process Date',Date,Time,'R Site',Status,Comments| 
        Export-csv C:\Powershell-Work\EmtyTest.csv -NoTypeInformation

    \_(ツ)_/

    Thursday, April 5, 2018 7:04 AM