I have a script that duplicates a Word doc template and renames each using a csv file with a list of names. What would be the equivalent code if instead of a csv file I use a text file?
Import-csv ‘.\individuals2.csv’ | foreach-object {
$newname = ‘2 ‘ + $_.name + '.docx’
Copy-item '.\template.docx' $newname
}
A csv file is a text file. Where the data in text form is in a specific form.
So your question doesn’t really make sense. You’re already using a text file, and you don’t disclose what would be different.
Oh I see. I thought only .txt files are text files.
I was trying to adjust the code so that it uses a .txt file instead of a .csv file.
What’s the format of the text file?
His example doesn’t seem to perform any comparisons to determine what to name the file. If the text file is just a list then something like this could work:
$file = Get-Content -Path .\individuals2.txt
foreach ($line in $file) { Copy-Item -Path .\template.docx -Destination “.$(2 + $line + ‘.docs’)” }
Edit: Wow, Lemmy destroys formatting.
It’s markdown, you should be able to indent your lines by 4 spaces or fence with triple backtics to get code blocks. Your client’s editor may have a button to help
``` $file = Get-Content -Path .\individuals2.txt foreach ($line in $file) { Copy-Item -Path .\template.docx -Destination ".\$(2 + $line + '.docs')" } ```Becomes
$file = Get-Content -Path .\individuals2.txt foreach ($line in $file) { Copy-Item -Path .\template.docx -Destination ".\$(2 + $line + '.docs')" }That’s good to know. Thanks!
Thanks for your help, but I had a couple errors pop up when I tried this out. I don’t need to input anything in the code you provided, do I?
Cannot convert value "VALUE" to type "System.Int32". Error: "Input string was not in a correct format." At line:4 char:55 + ... py-Item -Path .\template.docx -Destination ".\$(2 + $line + '.docs')" + ~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : InvalidCastFromStringToInteger Copy-Item : Cannot overwrite the item FILENAME with itself. At line:4 char:5 + Copy-Item -Path .\template.docx -Destination ".\$(2 + $line + '.d ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (FILENAME) [Copy-Item], IOException + FullyQualifiedErrorId : CopyError,Microsoft.PowerShell.Commands.CopyItemCommand
It’s just a Notepad text file.
The confusion is that CSV is also just a Notepad text file that uses Commas to Separate Values.
They are asking about what kind of values are in it.
Just words? It’s a list of names.