11
submitted 3 months ago* (last edited 3 months ago) by BobTheDestroyer@lemy.lol to c/powershell@programming.dev

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
[-] Gurfaild@feddit.de 2 points 3 months ago* (last edited 3 months ago)

That will crash if there is more than one line in individuals.txt, because by the second iteration '.\_2023 Summary Page.docx' has been renamed.

[-] BobTheDestroyer@lemy.lol 1 points 3 months ago

I see. Any suggestions on how to correct it?

[-] Gurfaild@feddit.de 1 points 3 months ago* (last edited 3 months ago)

Just use Copy-Item instead of Rename-Item if you want multiple identical files with different names

[-] BobTheDestroyer@lemy.lol 1 points 3 months ago

Actually they're all different files.

[-] Gurfaild@feddit.de 2 points 3 months ago

Then the snippet won't work because it only ever renames/copies the file '_2023 Summary Page.docx'. What are the actual names of the files you want to rename?

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

Powershell

939 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