Batch rename multiple files in powershell with a prefix

Question

i have more than 200 files in a folder

JOB1_CostReport.xlsx
JOB2_CostReport.xlsx
JOB4_CostReport.xlsx
JOB3_CostReport.xlsx
JOB7_CostReport.xlsx
....
JOB196_CostReport.xlsx
JOB200_CostReport.xlsx

I want to reanme all these files with a suffix like this : JOB1_CostReport_Aug_2020.xlsx

I have tried : Get-ChildItem | rename-item -NewName { $_.Name + "_Aug_2020" }

the result was like this :

JOB1_CostReport.xlsx_Aug_2020
JOB2_CostReport.xlsx_Aug_2020
JOB4_CostReport.xlsx_Aug_2020
JOB3_CostReport.xlsx_Aug_2020
JOB7_CostReport.xlsx_Aug_2020
JOB196_CostReport.xlsx_Aug_2020
JOB200_CostReport.xlsx_Aug_2020

what I want is more like :

JOB1_CostReport_Aug_2020.xlsx
JOB2_CostReport_Aug_2020.xlsx
JOB4_CostReport_Aug_2020.xlsx
JOB3_CostReport_Aug_2020.xlsx
JOB7_CostReport_Aug_2020.xlsx
JOB196_CostReport_Aug_2020.xlsx
JOB200_CostReport_Aug_2020.xlsx

Wai Ha Lee · Accepted Answer · 2020-10-17 09:34:37Z

2

try this:

Get-ChildItem | rename-item -NewName { $_.BaseName + "_Aug_2020" + $_.Extension}

edited Oct 17, 2020 at 9:34

Wai Ha Lee

8,856102 gold badges61 silver badges100 bronze badges

answered Oct 17, 2020 at 2:41

Drumor

4312 silver badges10 bronze badges

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

Comments

avarice · Accepted Answer · 2020-10-17 08:49:23Z

1

Besides @Brumor's excellent answer in powershell, and as you have tagged this question Cmd, so try this in a batch file:

for %%a in (*) do ren "%%~a" "%%~na_Aug_2020%%~xa"

PS when running in Cmd replace the %% to %.

answered Oct 17, 2020 at 8:49

avarice

15.6k3 gold badges19 silver badges38 bronze badges

Comments

m.imran38 · Accepted Answer · 2022-12-30 10:20:31Z

1

All the given answers rename the files multiple times(rename the file for 100 times if there are 100 files in the folder and it will add the prefix 100 times).

Use the following command in cmd:

for /f "tokens=*" %a in ('dir /b') do ren "%a" "%%~na_Aug_2020%%~xa"

answered Dec 30, 2022 at 10:20

m.imran38

214 bronze badges

Collectives™ on Stack Overflow

Batch rename multiple files in powershell with a prefix

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related