Newest functions Upload a function Leave a tip My account

There are 2,570 functions in this library.

FilePathToOS ( FMFilePath )

Convert from FileMaker filepath to OS filepath (HFS or NTFS)

  Average rating: 4.0 (40 votes) Log in to vote

Tom Robinson - Show more from this author

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

/* Convert from FileMaker filepath to OS filepath (HFS or NTFS) Convert the results from Get(FilePath) (‘file:’), a path in a file container field (‘filemac:’, ‘filewin:’), or an image container field (‘imagemac:’, ‘imagewin:’) to a form suitable for AppleScript, DOS, etc. Handles both absolute and relative paths. Examples: Container field on OS Ⅹ (‘image:’ and ‘size:’ are ignored): From: imagemac:/tom/Me Myself I/Programs/FileMaker Pro/Custom Functions/FilePathToOS/iphone%2F3g.jpg To: tom:Me Myself I:Programs:FileMaker Pro:Custom Functions:FilePathToOS:iphone/3g.jpg Get(FilePath) on OS Ⅹ: From: file:/tom/Me Myself I/Programs/FileMaker Pro/Custom Functions/FilePathToOS/FilePathToOS%2FTest.fp7 To: tom:Me Myself I:Programs:FileMaker Pro:Custom Functions:FilePathToOS:FilePathToOS/Test.fp7 Get(TemporaryPath) on OS Ⅹ: From: /Amphe/private/var/tmp/folders/501/TemporaryItems/FileMaker/ To: Amphe:private:var:tmp:folders:501:TemporaryItems:FileMaker: Container field on Windows (‘image:’ and ‘size:’ are ignored): From: imagewin:/C:/Documents and Settings/Administrator/My Documents/FilePathToOS/iphone3gwin.jpg To: C:\Documents and Settings\Administrator\My Documents\FilePathToOS\iphone3gwin.jpg Get(FilePath) on Windows: From: file:/C:/Documents and Settings/Administrator/My Documents/FilePathToOS/FilePathToOS Windows Test.fp7 To: C:\Documents and Settings\Administrator\My Documents\FilePathToOS\FilePathToOS Windows Test.fp7 Get(TemporaryPath) on Windows: From: /C:/Documents and Settings/Administrator/Local Settings/Temp/ To: C:\Documents and Settings\Administrator\Local Settings\Temp\ Author: 2008-08-14 Tom Robinson <http://www.tomrobinson.co.nz/> OS Ⅹ portion based on my FilePathToHFS custom function and supersedes that Change History: */ if(Abs(Get(SystemPlatform))=1; /* OS Ⅹ */ Let([ result="¶"&FMFilePath; /* Prepend a return for safety when searching for identifier */ pathpos=Case( PatternCount(result;"¶filemac:");Position(result;"¶filemac:";1;1)+8; /* 1st choice */ PatternCount(result;"¶imagemac:");Position(result;"¶imagemac:";1;1)+9; /* 2nd choice */ PatternCount(result;"¶file:");Position(result;"¶file:";1;1)+5; /* Last usual choice */ 1 /* No identifier (e.g. Get(TemporaryPath)) */ ); result=Right(result;Length(result)-pathpos); /* Everything post identifier to end of string */ result=GetValue(result;1); /* Reduce to first value in string */ result=If(Left(result;1)="/";Right(result;Length(result)-1);":"&result); /* Switch leading slash (FM absolute) for nothing (HFS absolute), and no leading slash (FM relative) for a colon (HFS relative) */ result=Substitute(result;["/";":"];["%2F";"/"]) /* Convert slashes to colons, encoded slashes to slashes */ ];result) ; /* Else Windoze */ Let([ result="¶"&FMFilePath; pathpos=Case( PatternCount(result;"¶filewin:");Position(result;"¶filewin:";1;1)+8; PatternCount(result;"¶imagewin:");Position(result;"¶imagewin:";1;1)+9; PatternCount(result;"¶file:");Position(result;"¶file:";1;1)+5; 1 ); result=Right(result;Length(result)-pathpos); /* Everything post identifier to end of string */ result=GetValue(result;1); /* Reduce to first value in string */ result=If(Left(result;1)="/";Right(result;Length(result)-1);result); /* Remove leading slash if present */ result=Substitute(result;["/";"\\"]) /* Convert slashes to backslashes */ ];result) ) Click to copy

Convert the results from Get(FilePath) (‘file:’), a path in a file container field (‘filemac:’, ‘filewin:’), or an image container field (‘imagemac:’, ‘imagewin:’) to a form suitable for AppleScript, DOS, etc. Handles both absolute and relative paths.

Examples:
Container field on OS Ⅹ (‘image:’ and ‘size:’ are ignored):
From: imagemac:/tom/Me Myself I/Programs/FileMaker Pro/Custom Functions/FilePathToOS/iphone%2F3g.jpg
To: tom:Me Myself I:Programs:FileMaker Pro:Custom Functions:FilePathToOS:iphone/3g.jpg

Get(FilePath) on OS Ⅹ:
From: file:/tom/Me Myself I/Programs/FileMaker Pro/Custom Functions/FilePathToOS/FilePathToOS%2FTest.fp7
To: tom:Me Myself I:Programs:FileMaker Pro:Custom Functions:FilePathToOS:FilePathToOS/Test.fp7

Get(TemporaryPath) on OS Ⅹ:
From: /Amphe/private/var/tmp/folders/501/TemporaryItems/FileMaker/
To: Amphe:private:var:tmp:folders:501:TemporaryItems:FileMaker:

Container field on Windows (‘image:’ and ‘size:’ are ignored):
From: imagewin:/C:/Documents and Settings/Administrator/My Documents/FilePathToOS/iphone3gwin.jpg
To: C:\Documents and Settings\Administrator\My Documents\FilePathToOS\iphone3gwin.jpg

Get(FilePath) on Windows:
From: file:/C:/Documents and Settings/Administrator/My Documents/FilePathToOS/FilePathToOS Windows Test.fp7
To: C:\Documents and Settings\Administrator\My Documents\FilePathToOS\FilePathToOS Windows Test.fp7

Get(TemporaryPath) on Windows:
From: /C:/Documents and Settings/Administrator/Local Settings/Temp/
To: C:\Documents and Settings\Administrator\Local Settings\Temp\

 

Comments

		Daniel A. Shockley, New York, NY Jul 14, 2010
You could change the pathpos test to something like the following to reduce function calls: result = FMFilePath; // NOTE: no longer need to prefix line-return to path pathpos = Case( "filemac:" = Left( result; 8 ); 8; "imagemac:" = Left( result; 9 ); 9; "file:" = Left( result; 5 ); 5; 0 ); Note that also removes the need to prefix a line-return symbol to the path, since we test only the leftmost characters. You can do the same for the Windows portion.

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: