Page 1 of 1
Custom script column of file's date's MINUTES; how to search for X?
Posted: 18 Oct 2025 21:43
by Rambo
I have a library of video files (TV shows mostly) - I set their attributes/dates as the original air date of the show.
For consistency, I also set the file time as 12 noon (and 00 minutes).
Anything else that is added, will have a different date/time (and 59 times out of 60, the file time will not have 00 minutes on it).
The 'new' files will have their original file attributes on them - the time the last person modified them, for example, which might be years ago.
I set a custom script/column to show the minutes, so that I can sort my search of the main folder by minutes, and then go down to the bottom to see all the 'new' files for processing.
How can I search for just those files where the file time is not "00 minutes" and simply get these 'new' files, as my only results?
Once they've been processed (converted, etc), they'll be given the air date/time with 00 minutes, so they do not show up on the next search.
Re: Custom script column of file's date's MINUTES; how to search for X?
Posted: 19 Oct 2025 12:11
by bossi
why not take path of least resistance and just tag the processed ones ?
XY can handle tens of tousands of tags .
also Script Columns that read Files Attribues are much slower than tags ...
Re: Custom script column of file's date's MINUTES; how to search for X?
Posted: 19 Oct 2025 23:43
by Rambo
I haven't fully figured out how tags work or what they can do, I will admit.
It took me a long time to figure out how to apply them (the Apply button in the documentation doesn't show up for me).
Also, I can't figure out how to search for files that are NOT tagged with a specific tag, which is, I think, what you're suggesting.
i.e. tag all my processed files, then search for any files not tagged...
I can't find a "not" filter, or similar option.
But in my testing, if a file is tagged, and then its attributes change (and they do occasionally), it's still tagged.
So that doesn't work for me.
I literally want to know the "current" MINUTES of the file date (I sync Created, Modified and Accessed all together).
And then search for any minutes that are not "00".But in my testing, if a file is tagged, and then its attributes change, it's still tagged.
So I don't think tagging would work for me.
If there's a better option than a script custom column (which was, when I started this, the only way I could get it to work), I'd welcome any advice.
If there's a tag option that says "if the file is altered in any way, remove the tags automatically", then that could work for me.
*using v25.8 until today, when I upgraded to v28.00 to test drag/drop tags (I can right-click & Set the tags, but I can't drag/drop files on a tag).
Re: Custom script column of file's date's MINUTES; how to search for X?
Posted: 22 Oct 2025 07:06
by bossi
tags:xyz -> shows only these files
!tags:xyz -> hides only these files
you can toggling Files Attribute Archive -> off , once a modification occurs it gets auto turned on
so "attr:A" would show these modified or unprocessed files
you then manually set it to off after processing
date method is nice , but would require someget property("date") or sth and then matching against the minutes or sth ..
imho me personally id check the date minutes via python and then set some file attr and select these files via attr:A O I or whatever )
Re: Custom script column of file's date's MINUTES; how to search for X?
Posted: 22 Oct 2025 08:07
by highend
Code: Select all
$files = quicksearch("/f", , , "m");
end (!$files), "No file(s) found, aborted!";
// name|size|modified
// Date assumed: 2025-10-22 07:41:48
$dates = regexreplace($files, "^(.+)(\|\d+\|)(.+?)(\|.+)$", "$1|$3");
$dates = regexreplace($dates, "^(.+)?\|([^ ])+[ ](\d+):(\d+):(\d+)", "$1|$4");
$final = regexmatches($dates, "^.+?\|(0[1-9]|[1-9][0-9])", <crlf>);
end (!$final), "No file(s) with !00 mins found, aborted!";
goto "vi:" . regexreplace($final, "\|\d+");