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