Saving files in a loop with generic file name

Question

How can I loop through a list of files, perform an operation and save the file to a new location with a name from a list?

As an example I have a list of CSV files, and a list of new names, I would like to do a simple operation on the CSV file like changing the delimiter and save each file to a new location with a new name from the list of names. How can I set the save path and new name correctly?

$files = Get-ChildItem C:\folder\*.csv
$te = Import-Csv C:\names.csv
For ($i=0; $i -lt $te.Length;$i++){
    Import-Csv $file -Delimiter "|" | Export-Csv -Path C:\another_folder\$te[$i].csv -Delimiter ","
}

To be precise, the problem is that the save path after the -Path statement is incorrect. How do I fix this?

Martin Brandl · Accepted Answer · 2017-05-12 07:54:34Z

1

You just need to wrap the path with quotes:

$files = Get-ChildItem C:\folder\*.csv
$te = Import-Csv C:\names.csv
For ($i=0; $i -lt $te.Length;$i++){
    Import-Csv $file -Delimiter "|" | Export-Csv -Path "C:\another_folder\$te[$i].csv" -Delimiter ","
}

answered May 12, 2017 at 7:54

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

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

Collectives™ on Stack Overflow

Saving files in a loop with generic file name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related