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

    ajayz

      Hello,

       

      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