BobTheDestroyer@lemy.lol to

Powershell@programming.dev · 7 months ago

Renaming multiple files based on a list of names

11

Renaming multiple files based on a list of names

BobTheDestroyer@lemy.lol to

Powershell@programming.dev · 7 months ago

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!

Chat

jj122@lemmings.world
link
fedilink
arrow-up
2·
7 months ago
Not sure about the word template thing and I know it’s not power shell, but bulk rename utility is basically everything you could want for renaming things plus it previews the change before you execute it.

https://www.bulkrenameutility.co.uk/
- BobTheDestroyer@lemy.lolOP
  link
  fedilink
  arrow-up
  2·
  7 months ago
  I got rid of that task. Now it’s just Task #1

Powershell@programming.dev

powershell@programming.dev

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !powershell@programming.dev

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:

Install PowerShell – Instructions for Windows, Linux, and macOS
PowerShell Galley Your one-stop shop community and Microsoft modules.
PowerShell Repository – View the PowerShell source code, report issues, or contribute to the project yourself.
PowerShell Community Call – Hear from and talk directly to the product team on the 3rd Thursday of every month
PowerShell in Visual Studio Code – It’s time to say goodbye to ISE

Rules:

Be civil (aka don’t be a jerk). Remember there are people from all walks of life, all with different levels of expertise. You can disagree with someone, but please be civil when doing so.
Adhere to the Lemmy Code of Conduct
Follow all programming.dev rules
Posts must relate to PowerShell or the PowerShell ecosystem.
Use code blocks to make things easier to read.
Memes and humorous posts are allowed but try not over do it. And keep them relevant to PowerShell
No discussion about piracy or hacking.
If someone provides an answer that solves your problem, please reply, so others know what the solution was. ^And ^so ^the ^person ^who ^suggested ^it ^gets ^that ^oh ^so ^sweet ^shot ^of ^dopamine.
If you find a solution to your problem by other means, please take your time to write down the steps you used to solve your problem in the original post. You can potentially help others having the same problem!

Self-promotion rules:

Self-promotion content must be marked as [OC]
Do not SPAM. Content must be PowerShell related.
Only 10% of your contributions can be self-promotion. In other words, 90% of your contribution must not be self-promotion.
Personal blogs are not considered self-promotion, at this time, as long as they are free to access and relevant. Please do not abuse this.

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

2 users / day
5 users / week
20 users / month
88 users / 6 months
48 local subscribers
1.02K subscribers
80 Posts
96 Comments
Modlog