Pulling folder, filename from a string

Discussion created by tlmurray on Jun 20, 2017
Latest reply on Jun 20, 2017 by rouelf

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?