• hisakimatama (11/9/2013)


    Huh, so doing that via command-line syntax is possible! Guess I slipped up on that one :-P. I seem to recall trying to do something similar via cmdshell before, and I didn't have a bit of luck with finding information on it. Clearly, I needed more Google-Fu :-D. Duly noted, Jeff!

    No problem. I just happen to be a big fan of DOS for doing certain things because the commands are sometimes so very easy to use compared (for me at least) to some of the PowerShell stuff (I gave up "programming" way back in 2002 so things like PowerShell have become a bit strange for me).

    As a bit of a sidebar, it's really kind of funny. Everyone said DOS was a "dead language" but the ForFiles command wasn't available until (IIRC) Windows Server 2003. Even XP didn't have it. Adding to that, RoboCopy and a couple of other goodies came out with Windows Vista/Windows 2008 and maybe it's not the "dead language" that everyone thought (I say after crossing heart and, with folded hands, looking pleadingly towards the sky :-)).

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)