r121a947
New member
- Joined
- Jun 29, 2019
- Messages
- 49
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
I have hundreds of folders, eachfolder containing from several dozen to several thousand .MP3 files. The program that creates the files adds a consecutive number to eachfile name (song title).
The program sometimes fails to convertall of the input songs, and the output folder does not have a filefor that song, with that song's consecutive number missing from thefolder.
I am looking for the best and easiestway to find which songs, if any, are missing from a folder . . .
I have a basic idea of what will work,but no idea how best to implement the steps:
A screenshot of the folder listing isattached. It shows that numbers 247, 255, 260, 264, 268, 270, and271 are missing.
Any and all help will be greatlyappreciated. Thanks, in advance.
The program sometimes fails to convertall of the input songs, and the output folder does not have a filefor that song, with that song's consecutive number missing from thefolder.
I am looking for the best and easiestway to find which songs, if any, are missing from a folder . . .
I have a basic idea of what will work,but no idea how best to implement the steps:
- Capture a folder's file list in a format that will easily paste/import into Excel, into individual columns.
- Extract the consecutive number from each file name, and place in a new column.
- Use a loop to compare row n+1 against row n; if the difference = 1, do nothing, next loop; else, place a character in a cell for row n+1, next loop.
A screenshot of the folder listing isattached. It shows that numbers 247, 255, 260, 264, 268, 270, and271 are missing.
Any and all help will be greatlyappreciated. Thanks, in advance.