How do i dynamically change file-names with Rename-Item?

Question

I'm trying to use the cmdlet Rename-Item to change the file name of multiple files in a folder. This is an example of my files (there are more files in reality):

1_File1.sql
1_File2.sql
1_File3.sql
2_File4.sql
3_File5_NOT_DONE.sql
3_File6_NOT_DONE.sql
3_File7_NOT_DONE.sql
3_File8_NOT_DONE.sql
4_File9_NOT_DONE.sql
5_File10_NOT_DONE.sql
6_File11.sql
6_File12.sql

What I wan't to do is remove the _NOT_DONE part from these files:

3_File5_NOT_DONE.sql
3_File6_NOT_DONE.sql
3_File7_NOT_DONE.sql
3_File8_NOT_DONE.sql

e.g. the files starting with 3_File

I wan't the complete list to look like this when I'm done:

1_File1.sql
1_File2.sql
1_File3.sql
2_File4.sql
3_File5.sql
3_File6.sql
3_File7.sql
3_File8.sql
4_File9_NOT_DONE.sql
5_File10_NOT_DONE.sql
6_File11.sql
6_File12.sql

I have tried using this in powershell and it gets all the files, but it forces me to set the new names to a static name (see the last part of the -Replace):

Get-ChildItem *.sql | Rename-Item -NewName {$_.name -Replace '3_File.*_NOT_DONE\.sql$', '<static filename>.sql'}

I would like to use regular expressions in the last part of -Replace as well. Or maybe there is another way to make the new names keep a part of their original name?

Answer 1

Maybe this would help you:

Get-ChildItem 3_*.sql | Rename-Item -NewName {$_.Name -replace "_NOT_DONE", ""}

Before: "3_File8_NOT_DONE.sql

After: "3_File8.sql"