Thanks to you all for your help, it's much appreciated however I appear to have missed something out which, in retrospect, is blindingly obvious.
I went with theDBguy solution and it works perfectly, however, although I now have "Last Folder" I also need (as separate field) the first part of...