Note: I’m a beginner to Powershell and a bit more familiar with Bash (though still a beginner for that too).

*I have multiple PDF files and I want to rename each file based on a list of names found in an Excel/CSV (could be a text file if easier) file.

*The list begins at the A2 cell and the A1 cell has the header ‘name’.

*The files are in sequential order and match the order of the list of names.

Thanks for your help!

  • @d3Xt3r@lemmy.nz
    3•9 months ago

    Well yeah, you need the full name of the file. PowerShell will not automatically asumme the extension of a file.

    Also that empty string error means there’s a blank line somewhere in your input list, so you’ll need to get rid of that.

    • @BobTheDestroyer@lemy.lolOP
      1•9 months ago

      Just figured it out! Added ‘.pdf’ in the second half of the command.

      $names = cat "\path\to\names.txt"; $i=0; dir | % { ren $_ "$($names[$i]).pdf"; $i++ }

      Thanks for all your help!