none
Converting txt to CSV specific columns RRS feed

  • Question

  • Hello Everyone,

    I am new to PowerShell so I was hoping for someone to point me in the right direction and not necessarily give me an answer.

    I have a text file (list of names) I would like to export to CSV.

    get-content file =$names

    In column A I would like the string format to read "\\$fileshare\users\$name" with the script asking for a user input for the fileshare location. Each cell in column A would have the format "\\$fileshare\users\$name".

    Then I would like to skip over to column D and have the string "https://nycourts-my.sharepoint.com/personal/'$name'_nycourts_gov"

    Column E would need to be autofilled with the string "Documents"

    If anyone can help point me in the right direction to get started that would be great.

    Much appreciated!

    • Moved by Bill_Stewart Friday, March 15, 2019 7:55 PM This is not "scripts on demand"
    Thursday, February 14, 2019 4:59 PM

All replies