Forum Discussion

Copper Contributor

Aug 31, 2022

Solved

Rename folders based on a column in a CSV file using PowerSehll

Hi Everyone, I'm a beginner to PowerShell. I have a scenario where I need to rename a large amount of folders (see below) in to a new name based on a column value in CSV. Current folders na...

Windows PowerShell

farismalaeb

Sep 01, 2022

VidRocksKay

You can use this code to fix it

$csv=Import-Csv -Path C:\boot\Book3.csv
Foreach ($Name in $csv){
    try {
        $Filter=$Name.SamAccount.Replace('.','') +'*'
        Get-ChildItem -Directory -Path C:\boot -Filter $Filter | Rename-Item -NewName $name.SamAccount
    }
    catch {
        $_.Exception.Message
    }


}

replace the Path and you are good to go

farismalaeb

Iron Contributor

Aug 31, 2022

VidRocksKay

as I can see, the folder name is UserName with no dot with a number

and the names in the CVS are usernames with a dot in the middle

are all the names following the same naming convention.?

VidRocksKay

Copper Contributor

Sep 01, 2022

farismalaeb
Thanks for your response. Yes the naming convention is consistently the same. I basically want "FirstLast-123" to be renamed to "First.Last".

farismalaeb
Iron Contributor
Sep 01, 2022
VidRocksKay
You can use this code to fix it
$csv=Import-Csv -Path C:\boot\Book3.csv Foreach ($Name in $csv){ try { $Filter=$Name.SamAccount.Replace('.','') +'*' Get-ChildItem -Directory -Path C:\boot -Filter $Filter | Rename-Item -NewName $name.SamAccount } catch { $_.Exception.Message } }
replace the Path and you are good to go
- VidRocksKay
  Copper Contributor
  Sep 01, 2022
  farismalaeb
  This worked like charm! Thanks so much for your prompt response and support to the community !
  Just to improve it a bit for everyone's benefit, could we add a line to handle duplicate ? (for instance, if the same name found in the folders, set "2 or 3" at the end).
  
  like - JonDoe-123 , JonDoe-456
  Renamed as JonDoe, JonDoe2
  
  Again, thanks very much !