Import pictures and tell filemaker to ignore the .jpg extension when matching records
I am trying to import pictures using the 'File -> Import Records -> Folder...
I have matched the source fields to target fields and told it to 'update matching records in found set'. I have told it to "match records based on this field" for a specific field but i am not getting the desired result. The issue is that the picture files are the same names as existing target fields, but they have a .jpg extension. I have tested this by changing one entry in the database to include .jpg as a name and it paired the picture successfully.
Is there any way around this? Ie to tell FileMaker to ignore the file extension?
Id appreciate any help!