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

Discussion created by ajayz on May 22, 2012
Latest reply on May 22, 2012 by ajayz



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