I am trying to strip off the .jpg extension in my filenames... but the query I am using returns nothing.
How do I filter a column full of serialized photo file names with Right function?
I have a column full of filenames of serialized photos:
I simply want to remove the .jpg extension using the Right function.
When I use the following formula in a query using the Right function in the criteria field it returns nothing?
(Ideally, I would like a query that would also strip out the "d3x" off the beginning of the filename as well, so I am left with just the numbers.)