Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    You Won't Believe It! (Any and All)

    I recently accepted a new position in a law office and "inherited" some problems that are mind boggling! One of which: They used to use Wordperfect in this office and the former legal assistant named the files WITH HER OWN EXTENSIONS! For example, if she was typing an answer to a complaint, she would name the file something like Williams, Jack.ans (the ans obviously I finally figured out means ANSWER!). She has used .req for a file containing a REQUEST; BRE for a file containing a Brief; LET (letter, of course!).

    Last year the office switched to Office XP and of course, all the Word Perfect files with a .wpd extension can be opened and then re-saved. I have taken to going into Explorer and choosing a directory (folder) and just changing a bunch at a time to .doc so I don't have to go through an open file/save file/delete file deal on all of these, but it's still tedious.

    The problem of course, is that the .req, .bre, let, etc., etc., etc. are not that easy since on some of them the drip didn't even use a client name, so now they all have to be opened and renamed. However, I am wondering if there isn't a way to speed up the problem and although I have never seen this done, wonder if there is not the availability in Explorer, or somehow or other, to globally change the extensions - I guess I'm thinking of something like a Find and Replace.

    Can anyone help?

    Thanks much!

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    Not familiar with Word Perfect, but was not aware that you could rename a file with another extension. Are you sure that the file (from the example in your post) is not named Williams, Jack.ans.wpd?

    Since some of the filenames do not include a client name, I would guess that there would probably not be a better way to determine what the file pertains to other than to open it and rename it. The folks in the Word forum might have an automated solution for this based on closing the file, but it might be more trouble that it is worth.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: You Won't Believe It! (Any and All)

    WP 5.1 for DOS and Windows let you choose any extension you wanted. With the eight-character limitation on the name, this was handy. Nowadays, of course, it would be fighting the system to continue doing it...

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: You Won't Believe It! (Any and All)

    Here is some script code I used last Fall during a conversion from old Mac files (no extensions at all) that you could adapt. I added the part in red just for you. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> You don't need the blue part. To use as is, slap it into a Notepad file and save as a .VBS:
    <pre>'Jefferson Scher 10/5/2001

    Sub AppendDotDoc()
    Dim oFSO, strFolder, oFolder, oFiles, oFile

    Do
    strFolder = InputBox("Enter mapped or local path to folder (not UNC)", _
    "Add .doc to files")
    If Len(Trim(strFolder)) = 0 Then Exit Sub

    'set up objects
    ' parent object from the scripting runtime
    Set oFSO = WScript.CreateObject("scripting.filesystemobject")
    ' get selected folder
    Set oFolder = oFSO.GetFolder(strFolder)
    ' collection of files in selected folder
    Set oFiles = oFolder.Files

    'rename all files in the folder
    For Each oFile In oFiles
    <font color=blue>'if there is not a period in the fourth to last position...
    If Mid(oFile.Name, Len(oFile.Name) - 3, 1) <> "." Then
    oFile.Name = Trim(Replace(oFile.Name, " ", " ")) & ".doc"
    End If</font color=blue>
    <font color=red> 'If no .wpd extension, add one
    If LCase(Right(oFile.Name, 4)) <> ".wpd" Then
    oFile.Name = Trim(oFile.Name) & ".wpd"
    End If
    'Code to remove all .wpd after testing!
    'If LCase(Right(oFile.Name, 4)) = ".wpd" Then
    ' oFile.Name = Left(oFile.Name, Len(oFile.Name) - 4)
    'End If</font color=red>
    Next

    Set oFiles = Nothing
    Set oFolder = Nothing
    Set oFSO = Nothing
    Loop
    End Sub
    '----------------------------------------------------------------------
    AppendDotDoc</pre>

    I don't recall why I was replacing internal double spaces in the file names with single spaces, so I left that out of the new code. Anyway, hope this helps.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    Oh, you take me back to my youthful days! <img src=/S/baby.gif border=0 alt=baby width=15 height=15> I've seen what you described lots and lots of times. That was the standard way of saving documents in WP many moons ago, and especially in law firms. Everyone could make up thier own syntax for extensions. We had .fm for form, .ltr for letter, and so on. Don't be shocked by this. At one time, it made sense to the users for thier own internal system. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Having said that, I have to admit, back in those days I warned users of future problems when extensions are standardized and we start exchanging files with other offices. But very few listened to me. <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

    I think I opened batches of documents at a time and wrote a macro that saved the file to a subfolder but as it's name with the proper extention (removing the false extenstion). So "Invitation020896.john.ltr" would become "Invitation020896.doc". It noted the file name and path of the open document, copied everything to the left of the first dot, and pasted that as the name and then added the .doc. It then closed the file. I had to then remove the old files.

    Is it a pain to deal with now? Yes. Was it unusual back then? No. You might check with some law groups about a quicker way to deal with this. I know they've ran into it before. If not, they haven't been around computers long enough. But don't be surprised if they still use that method and don't understand why you have a problem with it. It's a crazy world. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    -Lenny

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Toronto, Ontario
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    Can't offer you any quick fix but can sympathize, having been there twice!. In my experience I've come across WordPerfect files saved with any and all types of extensions: A06 (August 6); PMC (initials of the lawyer!), ltr, stm (statement), aff (affidavit), SOC (Statement of Claim), rev (revised), V02 (version 2) and so on. Fortunately the documents were kept in the folder pertaining to a particular client so that made it a little easier. A programmer did say he'd do the job but never produced but in the end did not matter as all files were being converted to Word. Maybe someone out there may have a solution such as a macro to replace all extensions. Best of luck!

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: You Won't Believe It! (Any and All)

    If none of the "extensions" the person used are already assigned to an application, you can edit file types to allow Word to open files with those extensions. Wouldn't that be easier than renaming them all first? Open any Windows explorer window or select Folder Options from the Control Panel and click the File Types tab. If you click on the New button, you can create a new file extension and assign it to an Word as the associated file type.
    Charlotte

  8. #8
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: You Won't Believe It! (Any and All)

    Hi,

    This should be easy to do from the MS-DOS prompt (if you've got access to it). No VBS required.
    If so, start a DOS session and use DOS to change directory (CD) to the folder with the rogue files
    (eg: CD C:"My DocumentsClient Files")
    Then, for each set of files with a given extension, use the DOS rename (REN) command to globally change the extensions
    (eg: REN *.ext *.wpd).
    Indeed, if every file in the folder has to be given the same extension (eg .wpd), the DOS command is as simple as
    REN *.* *.wpd

    HTH
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  9. #9
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    >This should be easy to do from the MS-DOS prompt

    Hmmm. That's sounds like an excellent solution, Macropod! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> And to think I threw away all my DOS books years ago. DOS is alive and well! Somebody get a memo to Gates. <img src=/S/rtfm.gif border=0 alt=rtfm width=24 height=23>

    -Lenny

  10. #10
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    No, she actually did name these the way I described - it was only at a later date that she began to let Wordperfect use the correct .wpd extension.

    Thanks

  11. #11
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    Thanks very much for shedding some light on this. It somewhat excuses what I saw except that how they could name a file w/o a client name is still beyond me.

    Thanks again

  12. #12
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    I can certainly try it! Somehow i got so lazy using Windows, I seemed to have forgotten the DOS basics I relied on for so many years.

  13. #13
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    There are also renaming utilities that rename mulitple files that can be downloaded free. One of them in RenamIt (but I'm not at a computer where I can find the URL). By the way, File Manager will do that by using wildcards. You still have winfile.exe, don't you?

    Seems to me you can open File Manager, scroll to a Directory, sort by extension (or type), & then rename en masse.

    Hope this helps.

  14. #14
    New Lounger
    Join Date
    Aug 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    If she named them with some consistency that you can track then you can probably still use a batch file to sort it out for you.

    if you use the extra options of the DIR command you can pipe the output to a file that you can then edit into a batch file.

    E.g. DIR *.ans /B /S > sample.bat

    This will find all files ending in .ans and list the path and file to a text file named sample.bat. You can then edit sample.bat to create the rename commands that you want.

    E.g.2 DIR *.ans.??? /B /S > sample.bat

    This example is the same except it lists files with a ".ans." toward the end of the name and three characters at the end of the file name itself (that the ???)

    With this you should be able to buid up a batch file that can be used to do some bulk renaming using the REN command.

  15. #15
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: You Won't Believe It! (Any and All)

    Jeez, where were all you with these solutions when I had to do this years ago? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Better yet, where are all those users now who created those crazy extensions when we told them not to? I think Microsoft hired them to work in Standards Control. Oops, did I say that? <img src=/S/hushmouth.gif border=0 alt=hushmouth width=16 height=16>

    -Lenny

Page 1 of 2 12 LastLast

Posting Permissions

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