Display File Extension in Doc. Library Column?

Question

I need to display the file extensions of the files in a Document library in a column. I have done a bunch of searching and came across solutions but they don't seem to be working for me.

This is what I have been trying to do:

1. Open SPD and select my list
2. Select the view that I want to add file extension column to
3. Since I already created the column in the list setting on SP I just right-click in the first row of that column and 'Insert Formula', then enter this: @FileLeafRef.Suffix

Now nothing happens, my items don't show the extensions in the column in SPD and not in SP either.

Is there something I am doing wrong with this?

Answer 1

Using as a formula

string(@LinkFilename)

should return the full name (extension included) of the document (notice that using @FileLeafRef should return the same results). So, if you want to use @FileLeafRef you should strip the name from the returned string. This formula

ddwrt:GetFileExtension(string(@FileLeafRef ))

should give the expected result.

As an alternative, you should be able to use:

@File_x0020_Type

(see this link, provided with screenshot).