By the way, what would be the equivalent code when using a text file for the list of names rather than a csv file?
Ah, I think that was it. Forgot about the column heading. Thanks for your help!
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!
So it sort of worked in that it outputed a bunch of files with the names but with blank icons and not the Adobe icons. Powershell also had an error for each list item that looked like the following:
Rename-Item : Cannot bind argument to parameter 'NewName' because it is an empty string.
At line:1 char:86
+ ... ads\individuals.txt"; $i=0; dir | % { ren $_ "$($names[$i])"; $i++ }
+ ~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [Rename-Item], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAllowed,Microsoft.PowerShell.Commands.Rena
meItemCommand
Maybe the command needs '.pdf' somewhere?
Hey this worked for me yesterday but now I'm having trouble getting it to work again. It just outputs a Word doc titled '.docx' now.
It manages to output one file titled 'name; 0++'
Actually they're all different files.
I see. Any suggestions on how to correct it?
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.
Also I had someone help with a similar task of duplicating a Word file that is renamed from a list of names found in a csv file. What would be the code when a txt file is used?
Import-csv ‘.\individuals.csv’ | foreach-object {
$newname = ‘2’ + $_.name + '.docx’
Copy-item '.\_2023 Summary Page.docx' $newname
}
Yeah it's a pretty simple task and I'm interested in getting more familiar with PS.
Thanks but I'm getting a 'Cannot create a file when that file already exists.' error. I checked the path so I am certain it is correct.
Perhaps my directions were unclear. The Excel/CSV file has the new names and I want to use them to replace the default names for the PDF files.
I got rid of that task. Now it's just Task #1
I got it now!
Nevermind I got it!
Renaming multiple files based on a list of names
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!
Actually nevermind that question. Just realized the command was split.
I'm assuming I need to replace the name portion of the 2nd line. What do I input if the data is a list that starts in A1?
So I'm new to all this. When I enter the first command with my csv file and doc file included, it just opens the word doc. Wasn't sure what I should do next.
Sorry I'm new to this. What exactly do I enter into Powershell for each step?
Powershell: Create multiple files from a Word template and rename using a list in Excel/CSV
I'm a beginner to Powershell and CLI in general, but this task does not need to use either so I'm open to using other tools.
I'm trying to do the following:
- Create multiple files from a Word template.
- Rename each file based on a list of names found in an Excel/CSV sheet.
Thanks in advance!