$substr(%date%,1,6)-$puts(y,$substr(%date%,8,9))$ifgreater($get(y),21,19,20)$get(y)

Your file data is too complex to process automatically. You'll need to do it all manually.

The title tag does indeed have the dates. Is there no mass command to add '20' if the value range is between '-00' to '17'?

I had another idea. All the live performances file names end in "-xx]"
Is that something syntax could be used for to make it to "-19xx]"?

$insert(%filename%,19,$sub($len(%filename%),3))

$insert(%filename%,$ifgreater($num($right(%filename%,3),2),31,19,20),$sub($len(%filename%),3))

%%. %title%

Quote from: kanishknishar on 2021-08-12 10:16:01

I had another idea. All the live performances file names end in "-xx]"
Is that something syntax could be used for to make it to "-19xx]"?

You only want to change the filenames?

Select the tracks that end in "-xx]" > right-click > File Operations > Rename to > select '...' and enter -

Code: [Select]

$insert(%filename%,19,$sub($len(%filename%),3))

^ This inserts 19 at 3 characters from the right.

Edit: Alternatively for either century...

Code: [Select]

$insert(%filename%,$ifgreater($num($right(%filename%,3),2),31,19,20),$sub($len(%filename%),3))

^ This tests "xx" and inserts 19 (if >31) or 20 (if <31) at 3 characters from the right. I think it should work for either century but always check the preview first.

The idea kode54 posted would work for tags except you needed more steps and having the steps in the correct order that was mentioned. Did you want to fix tags as well?

You can just copy filename to title if the above is sufficient - right-click tracks > Properties > Tools button > Automatically Fill Values > enter Pattern -

Code: [Select]

%%. %title%

^ If filename is "01. Get Back (01-12-2002)", title becomes "Get Back (01-12-2002)"

%title% HAS [live

%title% HAS [live AND NOT %title% HAS [DVD mix]

*-??].mp3

*-??].flac

Isn't there a way to set up a condition 'if last three letters are (between 70-99)] add 19 before (between 70-99)'?

And yes the formatting is consistent in that aspect. It's always ends for live tracks with [20-1-97] or [17-4-86] in the file name.

Quote from: kanishknishar on 2021-08-12 04:06:26

The title tag does indeed have the dates. Is there no mass command to add '20' if the value range is between '-00' to '17'?

You got like fifty CDs? That isn't much. Problem is if you are constantly getting new bootlegs in that old format. Then you need to be able to search up those which fit that pattern and ...

But if you only need to do it once, you can search up tracks for *-0?) OR *-1?) OR *-2?) and that will return everything that ends in -00) through -29) to get the 20 in front. You need to escape the parenthesis though. And if you have a mix of round parentheses and brackets, consider *??-??-0?? OR *??-??-1?? OR *??-??-2?? and see if that returns any false positives.
And then do similar to get the 19.

But, it is possible to code the 19 vs 20 in fb2k without IFs by using the fact that fb2k division rounds down to integer. $div(x,$max(x,22)) will return 0 if x is 0 through 21, and 1 if x is 22 or more. Subtract that from 20 to get 20 or 19 as appropriate.

What I would have done, is
* Split the track title between the first N-11 characters (to go into title) and the 8 running from N-9 to N-1 (to go into a new trackdateddmmyy tag).
* Fix the trackdateddmmyy tag into trackdate
* Apply a renaming that does not use "(" nor ")" for the dates, as parentheses are too commonly found in track titles. You can for example use a character like µ (the micron) or ¨; or if you insist on ASCII printable (non-"extended") I have no ` in metadata in my collection, and if you are equally lucky that character will uniquely be a separator. Say, 01. Get Back `01-12-2002.
... well of course you should use the useful date format for 01. Get Back `2002-12-01

Lastly using *-??] on Everything seems to have worked in bringing up all live tracks ... I managed to add them to foobar and here's the fpl if people need it for reference:

$insert(%filename%,$ifgreater($num($right(%filename%,3),2),31,19,20),$sub($len(%filename%),3))

Furthermore unless I had a live folder where yyyy-mm-dd would be beneficial by being chronoligcal using dd-mm-yyyy is vastly more preferable for searching because it's more intuitive for me.

Before things get more confusing let me clarify that both title and file names are identitical in how they end, i.e. [dd-mm-yy]

Quote from: kanishknishar on 2021-08-15 08:47:28

Before things get more confusing let me clarify that both title and file names are identitical in how they end, i.e. [dd-mm-yy]

... and always square brackets. That helps for identifying it.

If I were you I would still have considered to replace the "[" and "]" by something less likely to be found in actual titles though. If you have no "{" or "}" anywhere else, then a simple search for { would give you all those live dates and nothing else.

Quote from: kanishknishar on 2021-08-15 08:47:28

Lastly using *-??] on Everything seems to have worked in bringing up all live tracks ... I managed to add them to foobar and here's the fpl if people need it for reference:

Then you are good to go. Just switch to that playlist in foobar, select all tracks (CTRL-A), right-click > File Operations > Rename > '...' and enter -

Code: [Select]

$insert(%filename%,$ifgreater($num($right(%filename%,3),2),31,19,20),$sub($len(%filename%),3))

I checked the preview and both ranges of dates look fine, feel free to check it yourself before clicking Run.

Quote from: kanishknishar on 2021-08-15 08:47:28

Furthermore unless I had a live folder where yyyy-mm-dd would be beneficial by being chronoligcal using dd-mm-yyyy is vastly more preferable for searching because it's more intuitive for me.

For mind that suggestion was only for copying tags to the DATE field, where it should indeed be year first (the standard foobar recognizes for using $date functions)

For filenames / titles, either way is fine, whatever one prefers.

I did notice though your filename dates are actually month first (American standard) ... did you mean to change that? (That would be quite tricky because they also have no leading zeros, i.e. M-D-YY)

Why do you want me to replace it with a different type of parenthesis? Square brackets are unique to this archive AFAIK.

I did notice though your filename dates are actually month first (American standard) ... did you mean to change that? (That would be quite tricky because they also have no leading zeros, i.e. M-D-YY)

But my thought was it would take 4 searches (in Explorer), and 4-5 foobar rename operations, to account for each variation... i.e. insert 0 for [m-d-yyyy], [mm-d-yyyy], [m-dd-yyyy], and swap mm-dd.

(Again, foobar title formatting likes precision, there are no wildcards to help)

I actually had another look at Bulk Rename Utility, and inserting 0 can be done easily in that, but it looks like (unless I missed something) you'd need foobar to handle swapping characters. (Theoretically, I've not written any code)

So what do you want to do?

Also foobar2000 search queries can use wildcards, although it is undocumented in the help. I suppose %filename% IS *-0?] OR %filename% IS *-1?] OR %filename% IS *-2?] should return returns those which need the "20" inserted (am I right? Not on my home computer at the moment.)

I can't use BRU. It doesn't have a directory rename feature AFAIK so I am stuck with foobar file name renaming.

*[?-?-????]*
*?-??-????]*
*??-?-????]*