4
Powershell: How do I update my code to use a different file type? (lemy.lol)
submitted 3 months ago by BobTheDestroyer@lemy.lol to c/programming@beehaw.org
10 comments fedilink hide all child comments

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
}
top 10 comments
sorted by: hot top controversial new old
[-] Kissaki@beehaw.org 5 points 3 months ago* (last edited 3 months ago)

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.

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

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.

[-] EinfachUnersetzlich@lemm.ee 2 points 3 months ago

What's the format of the text file?

[-] mikyopii@programming.dev 3 points 3 months ago* (last edited 3 months ago)

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.

[-] brisk@aussie.zone 4 points 3 months ago

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')"
}
[-] mikyopii@programming.dev 1 points 3 months ago

That's good to know. Thanks!

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

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
[-] BobTheDestroyer@lemy.lol 1 points 3 months ago

It's just a Notepad text file.

[-] giloronfoo@beehaw.org 1 points 3 months ago* (last edited 3 months ago)

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.

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

Just words? It's a list of names.

this post was submitted on 28 Mar 2024
4 points (100.0% liked)

Programming

13226 readers
3 users here now

All things programming and coding related. Subcommunity of Technology.

This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 1 year ago
MODERATORS
alyaza@beehaw.org
Hexorg@beehaw.org
remington@beehaw.org