I am using 'GetAsText' to place the path and filename into a field. The paths and filenames are all rather long and I would like to extract only the part of the filename that comes after 'imagewin:/' ie just the Windows path from the local drive D. This is required for when I export data to Excel as the complete path reported by FM is far too long.
I've had lots of assistance from philmodjunk in extracting the filename extension which is working well but I just cannot get my head round calculations etc.
Two examples of the long path and filenames are shown below.
Thanks in advance
image:chs00013 x001 Cowbridge Record Society Newsletter 13 200905.pdf
imagewin:/D:/CHS Data Archive 01/DATA/Clubs and Societies/Record Society/CRS Newsletters/chs00013 x001 Cowbridge Record Society Newsletter 13 200905.pdf
image:../CHS Data Archive 01/DATA/Outlying villages/Aberthin/chs00708 Aberthin postcard 1955.jpg
imagewin:/D:/CHS Data Archive 01/DATA/Outlying villages/Aberthin/chs00708 Aberthin postcard 1955.jpg