Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[jacobacci]

Hi all,
A friend of mine has 120'000 untagged files in a given folder structure. I would like to help him extract the Artist and Album information contained in the folder names and put them into tags. The folder stucture is straightforward, but still a bit challenging:

W:\
  \Do not parse this directory\
    \Artist\
      \Do not parse this directory\
        \Album\
          \Sometimes there is a folder here indicating Disc 1,2,3\
            \filename.ext\

One of the difficulties is the Discx folder which sometimes exists and sometimes not. This means I need to parse the folder structure from the top (Root of W:\) and not from the bottom (filename.exe), as I would usually do. Also I need to ignore the content of two folder levels.
I plan to do this with F12 Fill Properties from Filename. I am familiar how to parse from the filename up, but not what expression to use to parse top down and to ignore a given folder level.
I would appreciate any suggestions.
Thanks a lot
Rudi

[glynor]

Inserting [] in the Fill Properties from Filemame template will “skip” that part of the string being parsed. Think of it just like filling a Field, but filling a special “null” field that goes nowhere.

It always parses from the file name up, not the reverse, but it is easy to skip sections as needed.

[glynor]

For the disc folders, are they prefixed with “disc” or any other text you can search for so that you can search for them and do them in a separate batch?

If not, there’s another way but it’ll take some more explaining...

[jacobacci]

Thanks a lot, Glynor
I had an idea how to do this, but I would need to use Regex, which I have very little experience with.
In reality the directory structure looks as follows:

For 80% of the library, it is quite standard:
W:\
  \ROCK A-F\
    \Artist\
      \Album\
This does not cause any issues.

For about 20% of the library (the 120'000 tracks in question) it is.
W:\
  \ROCK A-F\
    \Artist\
      \z_Outtakes & Live\
        \Album\
          \Sometimes there is a folder here indicating Disc 1,2,3\
            \filename.ext\
He uses this structure to find the outtakes (he browses by folders, as he has not tagged anything yet, which is the challenge).

The folder "z_Outtakes & Live" is always spelled exactly like this, so I could use it as an anchor. Artist sits above it and Album below it.

If I used Regex on filename(path) and parsed for "z_Outtakes & Live" and then extracted the text between the backslashes to the left and put it into the Artist Tag, I should be home. Same to the right for Album.

Then I would put the Regex into an expression column to check whether the output is correct. Finally put the Regex into the Artist and Album fields to fill them.

I have searched for a Regex example to do this, but have not found anything. How would I do this in Regex?

[jacobacci]

As this has turned into more of a Regex question, I will start a new thread with an adapted title.