Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Mossey]

Can someone supply the correct syntax for removing the file extension from an Image title? I have tried at least 50 variations and nothing returns the result I am looking for.
thanks ?

[Matt]

Just remove right the four characters.

For example:
RemoveRight(song.mp3, 4)

Will output:
song

[Mossey]

Sorry, thanks for trying to help but I am just to stupid to get it. I don't get the jist of which fields refers to what. All I get back when I tried your solution was the word, name. Currently in the field is
"[Filename (name)] " so now what and how am I refering to this or editing this output.

[Dirhael]

A more reliable way to do this (imo):

Add an expression column, with the following content:

Code: [Select]

Replace([Filename (name)], .[File Type],)
Matt's example will work in most cases, but will fail if the file has an extension with more or less than 3 characters (such as *.flac, *.jpeg etc.).

[glynor]

Just remove right the four characters.

For example:
RemoveRight(song.mp3, 4)

Will output:
song

Code: [Select]

Replace([Filename (name)], .[File Type],)
Matt's example will work in most cases, but will fail if the file has an extension with more or less than 3 characters (such as *.flac, *.jpeg etc.).

There's an easier way, which always works and always removes just the extension.

Filename(,0)

[Mossey]

Thanks very much for everyone's help. Problem is solved!