Dividing File Names into Sortable Columns

As a starting point

The config is stored in a global variable, so you can use this script to update that directly
global-variable-management-dialog .

{
  "columns": [
    {
      "name": "A",
      "label": "A",
      "header": "",
      "type": "text",
      "defwidth": "",
      "justify": "left",
      "infotiponly": false,
      "maxstars": "5",
      "datetimeformat": "yyyy-mm-dd",
      "nogroup": false,
      "grouporder": "",
      "sorting": "normal",
      "regexp": "(.*)\\^(.*)\\^(.*)\\^(.*)",
      "inputItemProperty": "name_stem",
      "firstValid": false,
      "output": "$1",
      "filter": "all",
      "graphLowerColor": "",
      "graphUpperColor": "",
      "graphColorThreshhold": ""
    },
    {
      "name": "B",
      "label": "B",
      "header": "",
      "type": "text",
      "defwidth": "",
      "justify": "left",
      "infotiponly": false,
      "maxstars": "5",
      "datetimeformat": "yyyy-mm-dd",
      "nogroup": false,
      "grouporder": "",
      "sorting": "normal",
      "regexp": "(.*)\\^(.*)\\^(.*)\\^(.*)",
      "inputItemProperty": "name_stem",
      "firstValid": false,
      "output": "$2",
      "filter": "all",
      "graphLowerColor": "",
      "graphUpperColor": "",
      "graphColorThreshhold": ""
    },
    {
      "name": "C",
      "label": "C",
      "header": "",
      "type": "text",
      "defwidth": "",
      "justify": "left",
      "infotiponly": false,
      "maxstars": "5",
      "datetimeformat": "yyyy-mm-dd",
      "nogroup": false,
      "grouporder": "",
      "sorting": "normal",
      "regexp": "(.*)\\^(.*)\\^(.*)\\^(.*)",
      "inputItemProperty": "name_stem",
      "firstValid": false,
      "output": "$3",
      "filter": "all",
      "graphLowerColor": "",
      "graphUpperColor": "",
      "graphColorThreshhold": ""
    },
    {
      "name": "Dname",
      "label": "Name",
      "header": "",
      "type": "text",
      "defwidth": "",
      "justify": "left",
      "infotiponly": false,
      "maxstars": "5",
      "datetimeformat": "yyyy-mm-dd",
      "nogroup": false,
      "grouporder": "",
      "sorting": "normal",
      "regexp": "(.*)\\^(.*)\\^(.*)\\^(.*)",
      "inputItemProperty": "name_stem",
      "firstValid": false,
      "output": "$4",
      "filter": "all",
      "graphLowerColor": "",
      "graphUpperColor": "",
      "graphColorThreshhold": ""
    }
  ]
}
1 Like