Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jul 2002
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dir ==>Excel (--)

    I'm a total putz with Excel - use it as an adding machine and occasionally as a formulary/converter. Having been given a bunch of CDs the other day, filled with a dozen folders each, each with hundreds of small files named (5-8).3, DOS-style, with a uniform extension, I wondered whether anyone had written an extension to grab (short only) filenames, uniq-out the dupes, sort, whitespace trim, and pump the filenames into a tab-delimited or comma-delimited format, ready for further messing around in Excel.

    Paradise would be a GUI front end allowing directory/child_directory pick/reject, and column (field) enable/disable for filename, extension, FQ (pathed) filename, filesize, mod date.

    Someone must have done this in the digital-camera or MP3 world. These filenames are like those, although in fact neither.

    Feel free to tell me I'm an idiot, and need to learn about Excel's table/database facilities, or not use the program at all! This is going to be a semi-repetitive task, with about 15,000 items. The task will have to be performed only 5-10 times, which is in the agony range, where automation is more trouble than it's worth. That's why I'm asking here.

    Thanks,
    Frank

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dir ==>Excel (--)

    Frank,

    Do you know that files with the same names, but in different folders, are actually dupes? Or does this not matter to you? I think it would be quite viable to produce such a listing in an Excel spreadsheet based purely on filename. If the filename appeared in Col A, and further path info in subsequent columns, it would be possible to sort on Col A, so grouping duplicate filenames together and allowing further processing to generate a listing of unique entries.

    But if you want to check for real duplicates - not just same names - you'll need a purpose-built utility. There are numerous about, some <img src=/S/free.gif border=0 alt=free width=30 height=15>.

    Alan

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Dir ==>Excel (--)

    Search this forum for file searches and see what fits, some possibilities may be <post#=294144>post 294144</post#> and <post#=265254>post 265254</post#>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Lounger
    Join Date
    Jul 2002
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dir ==>Excel (--)

    Thanks, all. Dupes with the same filename will be rare, and I don't actualy care (g). The information will be in the distribution of alphanumeric groupings in the filenames themselves, which is why I thought, "spreadsheet." The actual analysis would be done by those who know what they're doing (g, again).

    I'm going to play with this filesystem object stuff (my first essay ino O-O land), and see whether they buy me anything over DIR /B |SORT /BLAH >>OUT.FIL, plus a blank trim. Wish me luck.

Posting Permissions

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