+ Reply to Thread
Results 1 to 27 of 27

Renaming WAV Files in a Folder

Hybrid View

  1. #1
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: Renaming WAV Files in a Folder

    Dear Lewis,

     I'm glad you seemed to have success using my file.
    The results are phenomenal. Please accept my apologies for not supporting with examples. Please see my response below:

    What should the name of the SubFolder be? – It could be today's date. –

     Yes, that will be perfect, just that if the format could be “Renamed Copy - June 6, 2014”.
    Would it be possible to move the files that have exactly the same name before running the final command to a new folder, and keep only 1 “Unique” WAV file for processing the naming?

     A file is considered to be unique if has exactly the same naming convention up to “732914 2014-06-05 08_45_54 2345654321 -_ 1234567892”
     i.e. excluding the file name part, which is “ID_16184365”
    I’ve created the following folders for processing on my desktop:

    1). Main folder name: “My Voice”. Sub-folders within “My Voice”

    a). “WAV Files”. This has dump of all the WAV files
    b). “Duplicate WAV Files”. This is the folder to which all duplicate files should be moved from the “WAV” files folder, leaving only Unique files in WAV Files folder for renaming
    c). “Renamed Copy - June 6, 2014”. This is the folder that should have the copy of the renamed file

    Example:

    Step 1: let’s say all the file (listed below) exist in WAV Files folder
    Step 2: Move all the duplicate files from “WAV Files” to “Duplicate WAV Files” leaving only unique file in the WAV Files folder
    Step 3: Rename and Copy the Unique files in “Renamed Copy - June 6, 2014”. The original unique file should remain intact in the original folder(WAV Files) with the original name.

    Treating files:

    File: 732914 2014-06-05 08_45_54 2345654321 -_ 1234567892 ID_16184365 – Keep it in WAV Files for renaming
    File: 732914 2014-06-05 08_45_54 2345654321 -_ 1234567892 ID_16184367 – Duplicate, please move to Duplicate WAV Files folder

    File: 732922 2014-06-05 09_21_54 2345654321 -_ 1986312457 ID_16004368 – Keep it in WAV Files for renaming
    File: 732922 2014-06-05 09_21_54 2345654321 -_ 1986312457 ID_16024369 – Duplicate, please move to Duplicate WAV Files folder
    File: 732922 2014-06-05 09_21_54 2345654321 -_ 1986312457 ID_16014377 – Duplicate, please move to Duplicate WAV Files folder
    File: 732922 2014-06-05 09_21_54 2345654321 -_ 1986312457 ID_16034379 – Duplicate, please move to Duplicate WAV Files folder

    File: 732913 2014-06-05 13_21_54 2345654321 -_ 1234567890 ID_16184375 – Keep it in WAV Files for renaming
    File: 732913 2014-06-05 13_21_54 2345654321 -_ 1234567890 ID_16184368 – Duplicate, please move to Duplicate WAV Files folder
    File: 732913 2014-06-05 09_22_54 2345654321 -_ 1234567890 ID_16184375 – Keep it in WAV Files for renaming
    File: 732913 2014-06-05 09_22_54 2345654321 -_ 1234567890 ID_16184375 – Duplicate, please move to Duplicate WAV Files folder

    Hope I’ve explained it clearly. Really appreciate your efforts and time to help me out with this!

    Best regards,
    Spi
    Last edited by spiwere; 06-13-2014 at 05:33 AM.
    In your greatness, remain humble!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Listing/Renaming Files in a folder from excel
    By Kelshaer in forum Excel Tips
    Replies: 4
    Last Post: 01-23-2013, 11:04 AM
  2. Replies: 1
    Last Post: 01-15-2013, 03:05 AM
  3. Merging excel files + renaming them with folder name + restructuring them
    By BohkAl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2011, 07:47 AM
  4. Renaming multiple files in a Folder
    By csmithee in forum Excel General
    Replies: 1
    Last Post: 06-11-2009, 02:36 PM
  5. Excel files replicating and renaming in a folder
    By hpum in forum Excel General
    Replies: 0
    Last Post: 07-21-2007, 09:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1