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 !