6 Replies Latest reply on May 22, 2012 6:31 PM by ajayz

    How to remove the image extension .jpg and leave just the file name




      I've imported 3,000 odd images which are name with a site number ie: 0213906.jpg and I need to created a new calculated field that only display the text "0213906" ie without the extension.


      I need this to link to a table of data relating to this site number.


      Note: the field is called: FileName and I think I should be using the trim function but I couldn't get it to work correctly.


      thanks for your help