Formating file name

Question

Hello,
can you kindly advise if this is possible?

We need to print in number order rather than name order.
The file name is currently in the format <Name> <Store number>. We'd like it to be in <Store number> <Name>. Can you kindly support?

Answer 1

Hi,

Please refer to this link. This might be helpful to you

https://profitclaims.com/how-to-rename-multiple-files-at-once-with-sequential-numbers/#:~:text=%20How%20do%20I%20rename%20multiple%20files%20at,Rename%20files%20using%20a%20third-party%20program%20More%20

Thanks
Anshul

Answer 2

Hi @Callum Treadwell ,

this should do the job:

$AllFiles = Get-ChildItem "C:\Temp" -Filter *.PDF  
Foreach ($File in $AllFiles) {  
$FileName = $File.Name  
$StoreNumber = $FileName -replace "[^0-9]"  
$StoreName = ($FileName).Substring(0,$FileName.IndexOf($StoreNumber))  
$NewFileName = $StoreNumber + " " + $Storename + ".pdf"  
Rename-Item -Path $File.Fullname -NewName $NewFileName  
}  

This is of course under the consideration that all files follow the same naming convention - "StoreName StoreNumber".

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!)
Regards
Stoyan Chalakov

Answer 3

You can try this:

# just some test data  
$x = [PSCustomObject]@{BaseName='Anlaby 4688';FullName='c:\junk\Anlaby 4688'},  
[PSCustomObject]@{BaseName='Archway 4028';FullName='c:\junk\Archway 4028'},  
[PSCustomObject]@{BaseName='Arnos Grove 4952';FullName='c:\junk\Arnos Grove 4952'}  
  
$x |        # Replace this with your choice of file selection  
    ForEach-Object{  
        [PSCustomObject]@{  
            SortBy = ($_.BaseName -replace "^(.+?)\s(\d{4})$", '$2$1')  
            Orig   = $_  
        }  
    } |  
        Sort-Object -Property SortBy |  
            Select-Object -Expand Orig  

Answer 4

Hello there,

You can use the -replace operator together with a regular expression pattern to remove all strings from the start of the file name:

Get-ChildItem -Path C:\All -Filter *.pdf |
Rename-Item -NewName {$_.Name -replace '^\d+'}

A Windows PowerShell script for renaming files. https:// gist.github.com/csharpforevermore/94e6c1c4ca0ca1c2a91916fcd704dc92

-----------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept it as an answer–