Consider a path and filename, where the filename might have more than just one period; in other words, something like
I would like to develop two calculation fields, one to pick up the filename and one to pick up the last folder in the path. So for
one calculation is video-2016.10.23.mp4 and the other calculation is A_Folder. I can do this in a spreadsheet but can't figure it out in FileMaker. Any ideas?