PowerShell - loop through CSV, use entries in specified columns to create a .txt with the entries as variables

Question

I would like to loop through a CSV File and use the enties to create a .txt File.

CSV File would look like something like this:

Column1   Column2   Column3       
-------   -------   -------       
Systemname1  User1 PasswordtEX#
Systemname2  User2 Password4k2P
Systemname3  User3 Password3Uch
Systemname4  User4 PasswordY0}(
Systemname5  User5 PasswordDhE"
Systemname6  User6 Password1TOs

So the code I had in mind would look like that:

$data = Import-Csv 'C:\Path.csv' -Delimiter ";"

ForEach ( $Systemname in $data) {
"Systemname is $Systemname.Column1 and the User I'm going to use it named $User.Column2 with the Password $Password.Column3" Add-content | out-file -filepath C:\path.txt -Append
}

And the .txt File would look like that

Systemname is Systemname1 and the User I'm going to use is named User1 with the Password PasswordtEX#
Systemname is Systemname2 and the User I'm going to use is named User2 with the Password Password4k2P
Systemname is Systemname3 and the User I'm going to use is named User3 with the Password Password3Uch
Systemname is Systemname4 and the User I'm going to use is named User4 with the Password PasswordY0}(
.... And so on

Am I totally off track? Would appreciate any help! Thanks in regards!

"Am I totally off track?" - why don't you test your current code and find out for yourself? :-) — Mathias R. Jessen
– Mathias R. Jessen, Commented May 11, 2021 at 8:05

Ladi · Accepted Answer · 2021-05-11 09:00:48Z

1

I actually found a solution myself,

ForEach ( $Systemname in $data) {
$Hostname = $Systemname.Column1
$Benutzername = $Systemname.Column2
$pw = $Systemname.Column3

ForEach ( $Systemname in $data) {
"Systemname is $Hostname and the User I'm going to use it named $Benutzername with the Password $pw" | out-file -filepath 'C:\path.txt' -Append
}

I included variables in the foreach loop like that.

answered May 11, 2021 at 9:00

Ladi

133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Theo · Accepted Answer · 2021-05-11 18:25:14Z

You're really getting the hang of it I see.

Here's some more alternatives to do that without defining extra variables:

Using Subexpression

$data = Import-Csv 'C:\Path.csv' -Delimiter ";"
foreach ($item in $data) {
    "Systemname is $($item.Column1) and the User I'm going to use it named $($item.Column2) with the Password $($item.Column3)" | 
    Out-File -FilePath 'C:\path.txt' -Append
}

Using the -f Format operator

$data = Import-Csv 'C:\Path.csv' -Delimiter ";"
foreach ($item in $data) {
    "Systemname is {0} and the User I'm going to use it named {1} with the Password {2}" -f $item.Column1, $item.Column2, $item.Column3 | 
    Out-File -FilePath 'C:\path.txt' -Append
}

Using a ForEach-Object loop and the $_ Automatic variable
(here combined with the -f Format operator, piping the result to file straight away)

Import-Csv 'C:\Path.csv' -Delimiter ";" | ForEach-Object {
    "Systemname is {0} and the User I'm going to use it named {1} with the Password {2}" -f $_.Column1, $_.Column2, $_.Column3 | 
} | Out-File -FilePath 'C:\path.txt' -Append

Collectives™ on Stack Overflow

PowerShell - loop through CSV, use entries in specified columns to create a .txt with the entries as variables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related