Capture file extension on container export.
I have a database that has 3,000 images pasted into container fields. The problem is that they were pasted from different machine types and therefor have different file extentions.
When I rightclick the field filemaker suggests the name based on the file type:
untitled.wmf, untitled.bmp, untitled.pct, etc.
Is there anyway to extract the dot extension? "wmf", "pct", etc?
I set up a test file with a container field, PictureImage, and inserted an image into it. I set up a calculation field, PictureType, and extracted the text of the PictureImage field that was to the right of the period, and it set it to be 'JPG' or whatever.