How to remove a file extension after file upload

Hi everyone,

I’ve been trying to implement a file upload which adds the files name to the database after it finishes uploading.

I’ve tried using the Sub formatter with a negative value of (-4, 4) which just gets for example “.jpg” but not the rest of the file.

And starting from the start of the file with a sub there’s no way of knowing how long the string is.

I was thinking about implementing a lot of different replace ‘.jpg’ conditions but then I would need to account for many different file formats which seems redundant.

Any ideas?

Cheers