Project (part of file name) as Custom Column
Posted: 04 Sep 2017 06:00
I just discovered XYplorer one week ago and am very happy about all the things I can do that I thought are never possible when I was stuck with Microsoft Explorer. Over the last 20 years I collected many thousands of project files. I organized the files into folders by subject area. As a second dimension I wanted to capture the project that this file was created for. I looked into tags or other meta properties however these properties exist mainly for MS Office files. For pdf files, text files or other types of files there are no such file properties. So in order to be able to tag all my files regardless of file type I am maintaining a file suffix "_P#<Project>" for each file.
Using a custom column and scripting I am now able to have the project for each file in a separate column.
Very cool, now I can finally see my projects in a separate column. And I can sort by that column (and probably also filter and search which I will figure out next).
Using a custom column and scripting I am now able to have the project for each file in a separate column.
Code: Select all
$find = regexmatches(<cc_name>, "^(.*?_P#)", "$1");
$project = regexreplace(<cc_name>, "^(.*?_P#)(.*?(?=\.))(.*$)", "$2");
if (strlen($find) > 1) {return $project};- 2017-09-03_23-57-51.png (198.12 KiB) Viewed 1767 times
