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:
collectionname.yy.mm.dd.title.resolution.creator

For example
boats.20.12.22.sail.boat.1080p.fred.mp4

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