Can folders be automatically merged using the following Applet:

[Dan10]

Dir | Rename-Item -NewName { $_.name -replace "[0-9]",”” }

Only I have a lot of Folder names with numbers at their ends and they only rename one by one rather than merge where their names are the same after running the applet. Many thanks for any help.

 

[ExcelToDAX]

How about:

$folders = Get-ChildItem -Directory
foreach ($folder in $folders) {
    $newName = $folder.Name -replace "[0-9]", ""
    if (Test-Path -Path (Join-Path $folder.Parent $newName)) {
        Get-ChildItem -Path $folder.FullName | Move-Item -Destination (Join-Path $folder.Parent $newName) -Force
        Remove-Item -Path $folder.FullName -Recurse
    } else {
        Rename-Item -Path $folder.FullName -NewName $newName
    }
}

 

[Dan10]

How about:

$folders = Get-ChildItem -Directory
foreach ($folder in $folders) {
    $newName = $folder.Name -replace "[0-9]", ""
    if (Test-Path -Path (Join-Path $folder.Parent $newName)) {
        Get-ChildItem -Path $folder.FullName | Move-Item -Destination (Join-Path $folder.Parent $newName) -Force
        Remove-Item -Path $folder.FullName -Recurse
    } else {
        Rename-Item -Path $folder.FullName -NewName $newName
    }
}

Many thanks for this, I think its on the right track but...

I think its calculated the folder I set up but it looks to have removed all the other folders?! They are only copies and so it does not matter, just need to reimport the folders...

...I would like to be able to add multiple functions so say there is a 1 through to 9 on the end but some folders also have letters and words. Can you add a string to manage several items that you ask it to remove rather than just 1 through to 9?...and can you stop it from removing the other folders which I think it has done?

 

[ExcelToDAX]

How about:

$patternsToRemove = "[0-9]", "word1", "word2"  # Add as many as you'd like
$folders = Get-ChildItem -Directory
foreach ($folder in $folders) {
    $newName = $folder.Name
    foreach ($pattern in $patternsToRemove) {
        $newName = $newName -replace $pattern, ""
    }
    $newName = $newName.Trim()
    if (Test-Path -Path (Join-Path $folder.Parent $newName)) {
        Get-ChildItem -Path $folder.FullName | Move-Item -Destination (Join-Path $folder.Parent $newName) -Force
        Remove-Item -Path $folder.FullName -Recurse
    } else {
        Rename-Item -Path $folder.FullName -NewName $newName
    }
}

 

[Dan10]

Many thanks for this, I think its on the right track but...

I think its calculated the folder I set up but it looks to have removed all the other folders?! They are only copies and so it does not matter, just need to reimport the folders...

...I would like to be able to add multiple functions so say there is a 1 through to 9 on the end but some folders also have letters and words. Can you add a string to manage several items that you ask it to remove rather than just 1 through to 9?...and can you stop it from removing the other folders which I think it has done?

Thank you. It looks to have done the same again, merged one folder and removed the other/s whereas I need it to merge all the folders that apply and keep them where they are. I'm guessing its deleting the folders that do not apply?