Yeah, I just want the names of the folders, two deep. So my "S" Drive looks like this as one example reprinted from Powershell printout
S:\My Music\Live Concerts\Kinks
Mode LastWriteTime Length Name
---- ------------- ------ ----
d----- 2/22/2018 8:47 AM Kinks 1962-1972 All Aboard Video Compilation DVD
d----- 2/22/2018 8:47 AM Kinks 1965 07-07 L'Olympia, Paris France
d----- 2/22/2018 8:48 AM Kinks 1974 07-14 Hippodrome, London, UK
d----- 2/22/2018 8:48 AM Kinks 1974-04-04 Providence, RI
d----- 1/30/2020 10:13 PM Kinks 1977 12-24 Rainbow Theater, London, UK
d----- 2/22/2018 8:48 AM Kinks 1988 04-14 Fox Theater, St. Louis, Mo
Ideally, I would like to move this to an Excel Spread Sheet which under column A would have only the name of the artist folder
Kinks
Under Column B only the show, which I have named under Dime format
Kinks 1962-1972 All Aboard Video Compilation DVD
Kinks 1965 07-07 L'Olympia, Paris France
Kinks 1974 07-14 Hippodrome, London, UK
Kinks 1974-04-04 Providence, RI
Kinks 1977 12-24 Rainbow Theater, London, UK
Kinks 1988 04-14 Fox Theater, St. Louis, Mo
I suppose in a perfect world, column B would have track names (songs) but honestly, that is not necessary.
I looked at the Cathy media cataloging software and have only one question--has anyone here actually used it? I hesitate using strange software. Ideally, I suspect that Excel has a macro or add-on for just this purpose, as it would be perfect for cataloging files in an office environment, but I have not run across the macro yet.
In a pinch, thanks to if then else, I can play with powershell and output this to an Excel format. Powershell is pretty easy to learn, just noun-dash-verb, easier than the old DOS command lines. There are some good YouTubes out there
Thanks for everyone's responses, and if you have any other ideas, I'll check back in. Cataloging the music is my current pandemic project.