Extract columns from parts of filenames

I have many files that follow a very consistent format and it would be great if i could turn those fields into columns so i could sort them better.

The format is:

For example

Is it possible to create thse columns?

  • collectionname
  • yy
  • mm
  • dd
  • title
  • resolution
  • creator

And obviously i'd have another column with the same name so that If a file didn't match the format I could work with it normally.

You can do it using these add-ins:

1 Like