FileNameFromContainer ( containerField )

Get the file name of a file in a container field.

Average rating: 4.4 (25 votes) Log in to vote

Dan Shockley - Show more from this author

Sample input:

FileNameFromContainer ( MemberPhoto )

Sample output:

"SusanHill.jpg"

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// FileNameFromContainer ( containerField )
// version 1.0, Daniel A. Shockley

/* Get the file name (including extension) of a container field. */


/*
VERSION HISTORY:
	1.0 - initial version; properly handles removing "remote:" prefix if it appears. 
*/


Let ( [ 

	containerAsText = GetAsText ( containerField )
	; firstLine = GetValue ( containerAsText; 1 )
	; remotePrefix = "remote:"
	; fileNameOfContainer = If ( Left ( firstLine; Length ( remotePrefix ) ) = remotePrefix
		; Right ( firstLine; Length ( firstLine ) - Length ( remotePrefix ) )
		; firstLine
		)
	]; 

	fileNameOfContainer

)

Extracts the file name of a file inserted into a container field, including the extension.

Comments

		unix, Japan May 21, 2015
As of FM13 there is GetContainerAttribute(sourceField;"filename")

		Vyke, Washington DC Jul 6, 2015
Or...... you could just use: GetAsText(<container field>)

		Dan Shockley Jul 6, 2015
True about FileMaker 13, for those using it everywhere. As for just using GetAsText, read the function: there are situations where the GetAsText has a lot more than the name, even of the first line. That is too simple a solution and will fail in those situations.

		David Mar 22, 2017
You could also use GetContainerAttribute(Container;"Filename")

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

FileNameFromContainer ( containerField )

Comments

Support this website.

Support this website.