powershell create multiple files from csv with specific content

Question

So, the problem is that I must create a 300 ini files. In CSV file I have a computer names and MAC addresses. Ini files must be named as MAC addresses. For that I have solution:

$data = Import-CSV d:\import.csv
ForEach ($i in $data){

$name = $i.name
$MAC = $i.MAC

New-Item -ItemType file -name $_.MAC.ini
}

But in this code I need to put some txt in those inies. For example:

some value
some text
some value=$_.name
and more txt

The content must have the name of computer in some value which is in the same line as MAC address in CSV.

Here I need a help to do it. In first place I tried with Add-Content, but no luck :(

Justin Dunlap · Accepted Answer · 2013-02-21 19:20:28Z

2

Import-CSV d:\import.csv | %{ 
    "some value`r`nsome text`r`nsome value=$($_.name)`r`nand more txt" | sc "$($_.MAC).ini" 
}

% is shorthand for Foreach-Object and sc is an alias for Set-Content.

Be sure your MAC addresses use dashes and not colons, since colons are invalid in filenames.

answered Feb 21, 2013 at 19:20

Justin Dunlap

1812 silver badges4 bronze badges

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

1 Comment

user1662443 Over a year ago

Thanks mate! You are my savior!

Collectives™ on Stack Overflow

powershell create multiple files from csv with specific content

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related