Deleting certain amount of characters from end of value

I have images with filenames that have extensions including .jpg, .psd, .tif, and more. I would like to remove the file extension from all image file names. How can I make an expression the would remove the last 4 characters of all filenames? Using LEFT() wouldnโ€™t work becuase all filenames are of different lengths.

Solved Solved
0 7 1,046
1 ACCEPTED SOLUTION

LEFT([Filename], LEN([Filename])-3) or maybe 4 to get rid of the โ€˜.โ€™.

View solution in original post

7 REPLIES 7
Top Labels in this Space