We help IT Professionals succeed at work.
Get Started

Need a script to find and replace an underscore to a dash in a file name

2,091 Views
Last Modified: 2013-11-09
we get files that come into a folder on a server that look like this

151_JOE_Jones_2_17_2010__7_10_AM_.html
the system needs them to be
151-JOE_Jones_2_17_2010__7_10_AM_.html
currnetly we use better file rename to find and replace the first underscore "_" and replace with a dash "-"  but this is pain for end users  is there way i can do this with a batch file using standard DOS commands?  or perhaps a VBS script?  the folder may have 50 or so files a day.  Im ok with the end user having to click the VBS or BAT script.  the script will be read only once its created.  thanks !  ALso the first groupof numbers in the file name is a customer account number and is not always three digits it can be 3 to 5 digits.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE