How to replace specific string in a file name using powershell

Question

I am trying to write a powershell script which go to specific folder which have multiple folders containing Excel file. File name is as example 1_RIM_Reports_201510.xlsx 2_Rim_Reports_September.xlsx

Now I want to change replace the word RIM with NIR how can i do that for multiple files.

1_NIR_Reports_201510.xlsx 2_NIR_Reports_September.xlsx

Get-ChildItem $directory -Recurse |

    Rename-Item { $_.name -replace '*RIM*.xlsx', '*NIR*.xlsx' }

Avshalom · Accepted Answer · 2015-12-17 19:30:42Z

3

If your string always have the the underscore _ before and after you can simply use this:

Get-ChildItem $Directory -Recurse | 
Foreach-Object { Rename-Item $_.FullName ($_.FullName -replace "_RIN_","_NIR_")}

Otherwise you need to use Regular Expression, if this is the case let us know

answered Dec 17, 2015 at 19:30

Avshalom

8,9471 gold badge29 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Justin Over a year ago

Thanks it helped !! :)

Justin Over a year ago

how do you change the words in file if the word say RIM OLD Reports for consolidation how can i chagne it to RIM OLD Reports for consolidation?

Avshalom Over a year ago

Change the first section (before the comma) to any chars you like and the end section (after the comma) to the result you want "_RIN_","_NIR_"

Collectives™ on Stack Overflow

How to replace specific string in a file name using powershell

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related