Results 1 to 6 of 6

Thread: Batch Rename script needed for renaming files

  1. #1
    AUGI Addict madcadder's Avatar
    Join Date
    2000-11
    Location
    Too far from the beach
    Posts
    1,054
    Login to Give a bone
    0

    Default Batch Rename script needed for renaming files

    I have a text file that came to me with hundreds of entries double spaced.

    Each non-blank line is a NAME, a space, a CATEGORY, a space, a FILENAME w/ extension.



    I need to change the FILENAME to equal NAME with the FILENAMEs extension.




    How in the world can I automate doing this?

  2. #2
    Certified AUGI Addict cadtag's Avatar
    Join Date
    2000-12
    Location
    Cairo - no, not Illinois
    Posts
    5,069
    Login to Give a bone
    0

    Default Re: Batch Rename script needed for renaming files

    Import into a spreadsheet program (Excel or one of your choice)

    You should be able to parse into columns using the space as a delimiter.
    take the last column, and use the Text To Columns tool (In Excel it in the Data pulldown) and parse that out using the . as the delimiter.

    After that, select everything, and sort (That will put the blank lines down to the end.)

    final step is to combine the Name with the Extension. Again in excel, in the next column, (which should be "E") type in =CONCATENATE(A1,".",D1)

    That should give you the value that you want. Just highlight the rest of the column, and hit <CTRL>D to fill down.

  3. #3
    AUGI Addict madcadder's Avatar
    Join Date
    2000-11
    Location
    Too far from the beach
    Posts
    1,054
    Login to Give a bone
    0

    Default Re: Batch Rename script needed for renaming files

    You have got to be kidding me!!!!!

    I'm finished.

    Done!

    That easy.


    I have a meeting from 2:30-4:30, but after that I can start working on a script to actually rename the files in the folder.

    Awesome.

    Thank you very much!

  4. #4
    Super Moderator david_peterson's Avatar
    Join Date
    2002-09
    Location
    Madison, WI
    Posts
    5,687
    Login to Give a bone
    0

    Default Re: Batch Rename script needed for renaming files

    Depending on what you need to do, Here's some freeware that may help out.
    Or this one.

  5. #5
    All AUGI, all the time DoTheBIM's Avatar
    Join Date
    2005-02
    Location
    Central PA, USA
    Posts
    756
    Login to Give a bone
    0

    Default Re: Batch Rename script needed for renaming files

    I've also had a need to do what your asking with my personal picture files. I used a light weight program called ckrename. did exactly what I needed which was to filter by certain characters and replace those characters with new. I think I got it from download.com. doesn't have the mp3 tags stuff that david's does though.

  6. #6
    100 Club avdesign's Avatar
    Join Date
    2005-08
    Location
    STL Metro
    Posts
    173
    Login to Give a bone
    0

    Default Re: Batch Rename script needed for renaming files

    Quote Originally Posted by madcadder
    I can start working on a script to actually rename the files in the folder.
    Instead of a script try a free program called Lupas Rename it should do what you need to do.

Similar Threads

  1. Batch Rename Tool for Layout Tabs?
    By WhataMaroon in forum AutoCAD Customization
    Replies: 3
    Last Post: 2016-11-06, 03:01 AM
  2. batch renaming of views
    By Ricky Salmasan in forum Revit MEP - General
    Replies: 0
    Last Post: 2011-04-28, 03:43 AM
  3. Help writing a clean-up script to batch run on a set of DWG files
    By sumulong in forum AutoCAD Customization
    Replies: 3
    Last Post: 2007-01-29, 05:53 AM
  4. Free batch program to rename files
    By johan d in forum Software
    Replies: 4
    Last Post: 2006-07-26, 03:23 PM
  5. want to rename layers in a script
    By cooley28 in forum AutoCAD Customization
    Replies: 1
    Last Post: 2005-02-24, 06:41 PM

Posting Permissions

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