this post was submitted on 25 Mar 2024
11 points (100.0% liked)

Powershell

1023 readers
1 users here now

PowerShell (POSH) is a a task automation command-line shell and scripting language created by Microsoft. It became part of the FOSS community in 2016 and is now available across Windows, Linux, and macOS

Resources:


Rules:

Self-promotion rules:


founded 1 year ago
MODERATORS
 

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!

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 1 points 7 months ago (1 children)

Thanks but PS closes so I assume it ran into an error. I'm not sure why because there is the same number of files and list items. I doublechecked to make sure.

[–] [email protected] 1 points 7 months ago* (last edited 7 months ago)

I have no idea why this wouldn't work on your machine - I've tested it on mine and it works fine. So maybe you have overlooked some small things:

  • If there are any other PDFs in the directory that you don't want to rename, then the list of files is longer than the list of names.

  • If the PS window closes completely, you might have typed it into the terminal instead of running it as a script - then the problem might just be that you closed the if block too early, so PS immediately executes the exit command.

  • If your list of new names contains a column label like in a one-column CSV, then it has one more line than there are files.