String Functions in Calculated Field

[Rick6823]

Hello;

I currently have a product database (photo catalog) and I'm having a difficult time using string functions to create a calculated field based on the 'File Name' field.

I've named the product images with the product number (ex. rh0001.jpg). I'm trying to calculate the 'product number' field by stripping the .jpg from the 'File Name' field (ex. rh0001).

I've tried the formula: Product Number = File Name - Right(File Name, 4) and I get 0001 as a result. Does anyone know how to just strip the file extension from the File Name field?

Thanks in Advance for your help!!

Rick

[-Queue-]

Substitute( field, ".jpg", "" )

or in general

Left( field, Length( field ) - 4 )

[Rick6823]

Thanks Queue! I appreciate it very much!