Brian Dunning's FileMaker Custom Functions

RelativePath ( sourcePath ; targetPath ; separator )

Returns the relative path from the source file to the target file.

  Average rating: 4.3 (39 votes) Log in to vote

Michael Horak   Michael Horak
*COMMENT Visual Realisation
http://comment.cjb.net/

Share on Facebook Share on Twitter

  Sample input:
RelativePath (
"/Macintosh HD/Users/Documents/source.txt" ;
"/Macintosh HD/Users/Documents/target.txt" ;
"/" )

RelativePath (
"/Macintosh HD/Users/Documents/Origin/source.txt" ;
"/Macintosh HD/Users/Documents/target.txt" ;
"/" )

RelativePath (
"/Macintosh HD/Users/Documents/source.txt" ;
"/Macintosh HD/Users/Documents/Destination/target.txt" ;
"/" )

RelativePath (
"/Macintosh HD/Users/Documents/Origin/source.txt" ;
"/Macintosh HD/Users/Documents/Destination/target.txt" ;
"/" )
  Sample output:
target.txt




../target.txt




Destination/target.txt




../Destination/target.txt





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

Given two absolute paths, returns the relative path from the source file to the target file.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.