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! Go to Solution.
LEFT([Filename], LEN([Filename])-3)
or maybe 4 to get rid of the โ.โ.
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |