ShortDoc ( doc ; len )

Show abbreviated pathnam when using full filenames.

Average rating: 4.2 (30 votes) Log in to vote

Hartger Visser
Teuker Beheer BV
http://www.teuker.nl

Sample input:

ShortDoc ( l:templatesmergedocsnewuserirenenamed1.doc , 20 )

Sample output:

l:templatesmerged...named1.doc

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

/*---------------------------------------------
Function Name: DocShort (WIN ONLY)
Syntax:
DocShort ( DocumentFullPathName ; LengthOfStringReturned )

Returns a shortened path to a file + filename to improve readability when using long file location. 

l:templatesmergedocsnewuserirenenamed1.doc
is transferred to:
l:templatesmerged...named1.doc 
when len = 20.

Author - Hartger Visser
-----------------------------------------------*/

If ( Length ( doc ) > len ; Left ( Substitute ( doc; Middle ( doc ; Position ( doc ; "\" ; 1; PatternCount ( doc ; "\" ) ) ; 9999 ) ; "") ; len -  Middle ( 
doc ; Position ( doc ; "\" ; 1; PatternCount ( doc ; "\" ) ) ; 9999 ) ) & "..." & Middle ( doc ; Position ( doc ; "\" ; 1; PatternCount ( doc ; "\" ) ) ;  9999 ) ; doc )

Returns a shortened path to a file + filename to improve readability when using long file location names in lists etc.

Comments

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

ShortDoc ( doc ; len )

Comments

Support this website.

Support this website.