Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Using Powershell to delimit a file by a specific header RRS feed

 > 

  • General discussion

  • Discussion
    Sign in to vote
    0
    Sign in to vote
    Hello, I have a CSV file with file paths are on the same line separated by a semicolon. I would like to import that file into powershell, separate the path after the semicolon to a new row, and export back out of powershell. Any suggestions on how I can perform this task based on column header?
    • Changed type Bill_Stewart Wednesday, June 17, 2020 1:22 PM
    • Moved by Bill_Stewart Wednesday, June 17, 2020 1:22 PM Unanswerable drive-by question
    Wednesday, May 13, 2020 12:55 PM

All replies

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    You will have to use "-split" on the line in the file to c4reate an array that can be output to a file as rows.

    \_(ツ)_/


    • Edited by jrv Wednesday, May 13, 2020 1:06 PM
    Wednesday, May 13, 2020 1:06 PM
  • Discussion
    Sign in to vote
    0
    Sign in to vote
    Please provide a sample input and output. Usually I would recommend Import-Csv.

    -- Bill Stewart [Bill_Stewart]

    Thursday, May 14, 2020 1:27 PM