Hi All,
Just an updated. I had some help via email from a kind gentlemen and during those discussions, my thoughts on how I should handle the sorting of my data, views and the ultimate decision to tag on auto-import or use these views. I think i've opted to use the views as it's quite powerful and I can easily see if ive missed or incorrectly tagged something
What was created is a paned view, with the expressions and a explanation
Here is the expressions
Column 1:
listitem([filename (path)], 4, \)
Explanation: The ListItem() function splits a string on the named separator, in this case \, and returns the designated component.
Column 2:
regex([Filename (path)], /#.*?\\Media\\Images\\[^\\]+\\(.+)$#/, 1)&datatype=[list]
Explanation: matches the pattern of anything followed by the string "\Media\Images", and then followed by any sequence of 1 or more non-\ characters, followed by a \, and then anything else. The ( ) chars remember what was matched (captured) in those positions. And the 1 in the Regex() returns the value of capture #1. The &datatype=[list]
forces the resulting string to be interpreted as a hierarchy (a collapsible list in a pane, a drill down sequence in a categories view), and the \ char in a list is the reserved hierarchy list separator in MC views.
Column 3:
Replace(regex([Filename (path)], /#.*?\\Media\\Images\\[^\\]+\\(.+)$#/, 1), \, ;)&datatype=[list]
Explanation: Similar to column 2 but replace the \ list hierarchy separator with a semicolon, as semicolons are list item terminators (e.g. "a; b; c" will be shown as individual items a, and b, and c in a list).
Hopefully the above helps someone else as greatly as the email conversation helped me.