locked
PowerShell can not find a part of a path specified with Export-CSV command. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have this code-line to export a file:

    epcsv "c:\temp\My schedule Home/Work.csv" -NoT
     

    But I get an error that PowerShell couldn't find a part of a path. Probably its de slash between "Home" and "Work causing the error. How can I solve ?

    I have tried: ..."c:\temp\My schedule Home"+"/"+"Work.csv". But no luck

    this.Greetings, P

    Sunday, January 13, 2019 4:34 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    See the following test:

    PS D:\scripts> [io.path]::GetInvalidFileNameChars() -contains '/'
True
PS D:\scripts>

    \_(ツ)_/

    • Marked as answer by PeetK Sunday, January 13, 2019 5:32 PM
    Sunday, January 13, 2019 5:02 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Is c:\temp and "c:\temp\My schedule Home" standard directories? This error usually means, that the path does not exist. Please try to run 
    mkdir "c:\temp\My schedule Home" -force
    before running your command.

    M.

    Sunday, January 13, 2019 4:46 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The directory path must be valid before u export file. Export-CSV cant create directory for you.
    Sunday, January 13, 2019 4:48 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    The "/" character is not legal in a file name.

    \_(ツ)_/

    Sunday, January 13, 2019 4:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    See the following test:

    PS D:\scripts> [io.path]::GetInvalidFileNameChars() -contains '/'
True
PS D:\scripts>

    \_(ツ)_/

    • Marked as answer by PeetK Sunday, January 13, 2019 5:32 PM
    Sunday, January 13, 2019 5:02 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    Something happend to my commend before, it is deleted. As jrv posted you need to use backslash

    epcsv "c:\temp\My schedule Home\Work.csv" -NoT
    -----------------------------------------------------------------------------------------------------------
    If you found this post helpful, please give it a "Helpful" vote. 
    Please remember to mark the replies as answers if they help.

    Sunday, January 13, 2019 5:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The chararacter / does not belong to a path, its a character I use in the name of the file.
    Sunday, January 13, 2019 5:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Oke I understand now. The / is not a valid character in a file name. Thank you for the information. Gr. Peter
    Sunday, January 13, 2019 5:32 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Something happend to my commend before, it is deleted. As jrv posted you need to use backslash

    epcsv "c:\temp\My schedule Home\Work.csv" -NoT
    -----------------------------------------------------------------------------------------------------------
    If you found this post helpful, please give it a "Helpful" vote. 
    Please remember to mark the replies as answers if they help.

    I repeat.  You cannot use either / or \ in a file name.

    \_(ツ)_/

    Sunday, January 13, 2019 7:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The chararacter / does not belong to a path, its a character I use in the name of the file.

    It is not allowed in a file name.  If you force it then the name will be inaccessible by most utilities.  PS will not allow you to create a file with this name.

    \_(ツ)_/

    Sunday, January 13, 2019 7:52 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The basic NTFS documentation:

    https://docs.microsoft.com/en-us/windows/desktop/FileIO/naming-a-file#naming_conventions

    https://en.wikipedia.org/wiki/NTFS

    https://docs.microsoft.com/en-us/windows/desktop/FileIO/file-management

    \_(ツ)_/

    Sunday, January 13, 2019 7:58 PM