PowerShell optimize Rename-Item -NewName using Split method

Question

In short I'm inserting a hardcoded value 'USA' into the middle of the file name. My code currently works however I feel like it could be optimized, maybe by using -replace operator and RegEx or less returned values (everything before the 4th delimiter '.' + 'USA' + everything after) rather than returning 12 values (0 position + '.' + 1 position + '.' + 2 position + '.' + 3 position + '.' + 'USA' + '.' + 4 position + $_.Extension). Or maybe using the Insert method after the 4th delimiter? I'm iterating through a directory that has several hundreds of subfolders and renaming the '.xlsx' files in the '2023' subfolders. There is usually a folder within '2023' called 'Misc'. I don't want to rename those '.xlsx' files, just the ones in '2023'. I'm sure I can even tighten this up and only look for '.xlsx' files that have 4 '.' in the filename (not inlcuding file entension or new value, 'USA') so I'm not renaming other '.xlsx' files with '.' in the file name.

Current file naming convention: comp_id.process_id.comp_name.state.date.xlsx

Ex: 12345.001.chris_comp.NY.2023_08_22.xlsx

Desired filename naming convention, insert hardcoded value 'USA' after the 4th delimiter '.' so it would look like this: comp_id.process_id.comp_name.USA.date.xlsx

Ex: 12345.001.chris_comp.NY.USA.2023_08_22.xlsx

#renameFile
$numberedFolder = 'C:\Users\Documents\My Documents\PowerShell\Test'
$excludeFolder = 'Misc'
$delimiter = '.'
$excelFile = '.xlsx'
$search = Get-ChildItem -Path $nuberedFolder -Filter '2023' -Recurse
ForEach ($path in $search.fullname) {
Get-ChildItem -Path $path | Where-Object {($_.Extension -match $excelFile)} | 
Rename-Item -NewName {$_.Name.Split($delimiter)[0] + '.' + $_.Name.Split($delimiter)[1] + '.' + $_.Name.Split($delimiter)[2] + '.' + $_.Name.Split($delimiter)[3] + '.' + 'USA' + '.' + $_.Name.Split($delimiter)[4] + $_.Extension} -WhatIf
}

mklement0 · Accepted Answer · 2023-08-23T15:05:54.600

Indeed, the regex-based -replace operator offers a concise solution:

... |
 Rename-Item -NewName { $_.Name -replace '(?:[^.]+\.){4}', '$&USA.' } -WhatIf

For an explanation of the regex and the substitution expression, along with the option to experiment with them, see this regex101.com page.

Furthermore, you can streamline your overall command as follows:

Get-ChildItem -Directory -Recurse -LiteralPath $numberedFolder -Filter '2023' |
  Get-ChildItem -File -Filter '*.*.*.*.*.xlsx' |
  Rename-Item -NewName { $_.Name -replace '(?:[^.]+\.){4}', '$&USA.' } -WhatIf

PowerShell optimize Rename-Item -NewName using Split method

1 Answers1

Linked