Get the file name from attachment field

Naftuli_Singer · 12-01-2020 01:21 PM

I wanted to get the Fila Name from an “attachment field”, so I came up with this formula for a “Text” type column (VC).

Basically, if you use [Attachment] only it will come up as: "Attachments_Files_/The file name

I wanted to have just the file name, so I used this formula (Note: “Attachments_Files_/”= 19 Characters):

RIGHT([Attachment],LEN([Attachment]&"")-19)

Marc_Dillon

INDEX() and SPLIT() is another option here.

INDEX( SPLIT( [Attachment] , “/” ) , 2 )

Naftuli_Singer