AnsweredAssumed Answered

Extract part of a text field

Question asked by frimages on Feb 26, 2018
Latest reply on Mar 2, 2018 by philmodjunk

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

Frank

 

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

 

size:3380,2226

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

Outcomes