Dividing File Names into Sortable Columns

Hi all,
I was wondering if there is a way to split file names into seperate columns. In the example photo attached, you'll see that ive been splitting the file into 4 columns using ^. I will then copy these file names into Excel to be able to sort and organize by each "column" to find the missing ranges. Is there way to do this? Thanks for you help!!!

There are a few scripts that can do this, for example:

1 Like

Im going to give it a shot! thanks so much!

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