Solved

Need simple batch file rename utility (actually truncation)

Posted on 2011-02-22
7
386 Views
Last Modified: 2012-08-14
I installed a utility called Outlook Data Export to export Outlook Notes to text files. Unfortunately it adds what looks to be the date and time onto the beginning of each resulting exported file, like this.

20100618-1253 A dozen ways to eject or unmou.txt

I checked the option to put the first 30 characters of the file into the name so that I can see what it contains. When I created each Outlook Note I put a title in the first line of the note so checking this option really helps to see those, but I don't want all those numbers at the beginning.

Most batch file rename utilities I've found in a Google search have all sorts of fancy capabilities but I just need to remove the data & time numbers from the beginning. I have about 1500 Notes so I really need some batch utility to do this.

I tried the Windows Explorer rename function that I saw described on the web but it changes all the names to the name of the example file, which I don't want. I just want to remove the date and time from the beginning of all the files.

I don't see any zone that applies to this other than Windows.

Thanks,
donander
0
Comment
Question by:donander
  • 3
  • 2
  • 2
7 Comments
 
LVL 3

Accepted Solution

by:
KCarney81 earned 250 total points
ID: 34953575
There is a utility that I use to do something similar.  If you are proficient in batch scripting read the tutorial and FAQs on the site here:  http://www.bulkrenameutility.co.uk/Main_Intro.php
0
 
LVL 2

Expert Comment

by:ScintillateRich
ID: 34953648
If you're happy to use VBScript then you can use the split function.

Hang on, I'll see if I can find an example.
0
 

Author Comment

by:donander
ID: 34953658
ScintillateRich:

Please don't look for the example. The utility that KCaryey81 suggested works wonderfully.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 2

Expert Comment

by:ScintillateRich
ID: 34953666
OK thanks for letting me know.
0
 

Author Comment

by:donander
ID: 34953695
KCarney81,

This is fantastic!!! I was skeptical that it would work as I am not proficient in scripting but I saw that the main product is GUI. I installed it and within 5 minutes was able to complete the task I needed. I think it is so excellent that they have the function to just remove the first n characters, regardless. No matching or anything. Just remove the first 14 characters and you're done!!

I will accept your comment as the solution but just wanted to tell you how much I appreciate your fast and accurate comment.

Thanks very much,
donander
0
 

Author Closing Comment

by:donander
ID: 34953720
It is too bad they don't have an A+ grade available because this solution deserves it. It was the fastest and most accurate solution I have ever received on EE.

Thanks,
donander
0
 
LVL 3

Expert Comment

by:KCarney81
ID: 34953734
I highly recommend that product to anyone and everyone I can, it is simply indispensable.  I am glad you are happy with it donander!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Can you find a fax from a vendor you saved a decade ago in seconds? Have you ever cursed your PC under your breath during an audit because you couldn’t find the requested statement or driver history?  If you answered no to the first question or yes …
cPanel is a Unix based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site. cPanel utilizes a 3 tier structure that provides functionality for administrators, rese…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now