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.
What’s the format of the 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.
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.
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 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')"
}
