FMPToTRIO ( FMP_GetPath )

Converts FMP GetPaths to TROI File Plug-in Paths

Average rating: 4.7 (29 votes) Log in to vote

Don Wieland - Show more from this author
DW Data Concepts
http://dwdataconcepts.com

Sample input:

FMPToTRIO( "/Macintosh HD2/Users/DWDC/Desktop/" )

FMPToTRIO( "/C:/Documents and Settings/DWDC/Desktop/" )

Sample output:

Macintosh HD2:Users:DWDC:Desktop

C:\Documents and Settings\Users\DWDC\Desktop

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

Let([
x = FMP_GethPath;
l = Length(x);
p=Abs(Get(SystemPlatform)) = 1;

mr=Substitute(Middle(x; 2; If(Right(x; 1) = "/"; l-2; l- 1)); "/"; ":");

wr=Substitute(Middle(x; 2; If(Right(x; 1) = "/"; l-2; l- 1)); "/"; "\\")

]
;

If(  p ; mr; wr)
)

Converts FMP GetPaths to TROI File Plug-in Paths. Takes into consideration MAC and WINDOWS platforms.

Comments

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

FMPToTRIO ( FMP_GetPath )

Comments

Support this website.

Support this website.