Script Format_FMPath_to_AppleScripPath

An FM Script for parsing and formatting FM absolute file path to Applescript absolute file path

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

Edward Souza
Duana A.S. Designs
http://I_Don't_Have_One.com

Sample input:

_FM_Path (
Computer_Name:Users:Main_User:Music:iTunes:iTunes Music:Brad Mehldau:The Art of the Trio:01 Blame It On My Youth.mp3 )

Sample output:

AppleScript_Path( 01 Blame It On My Youth.mp3" of folder "Brad Mehldau" of folder "iTunes Music" of folder "iTunes" of folder "Music" of folder "Main_User" of folder "Users" of folder "Computer_Name" of startup disk )

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

Allow User Abort [ Off ] 
Set Field [ _g_num_temp; PatternCount ( _FM_Path ; ":" ) ] 
Set Field [ _g_text_temp; Right ( FM_Path ; 
Length ( FM_Path )  - ( Position ( FM_Path ; ":" ; 1 ; _g_num_temp ) ) ) ] 
Loop 
Set Field [ _g_num_temp; _g_num_temp - 1 ] 
Set Field [ _g_text_temp; _g_text_temp & " of folder " & 
Quote ( 
Middle ( FM_Path ; 
Position ( FM_Path ; ":" ; 1 ; _g_num_temp - 1 ) + 1; 
Position ( FM_Path ; ":" ; 1 ; _g_num_temp ) - 
Position ( FM_Path ; ":" ; 1 ; _g_num_temp - 1 ) - 1) 
) ] 
Exit Loop If [ IsEmpty ( _g_num_temp ) or _g_num_temp = 0 ] 
End Loop 
Set Field [ _g_text_temp; Left ( _g_text_temp ; 
Length ( _g_text_temp ) - 9 
 ) & 
"startup disk" ] 
Set Field [ _g_text_temp; Quote ( 
Left ( _g_text_temp ; 
Position ( _g_text_temp ; "of folder" ; 1 ; 1 ) - 2 
 ) 
 ) & 
Right ( _g_text_temp ; 
Length ( _g_text_temp ) - Position ( _g_text_temp ; "of folder" ; 1 ; 1 )  + 2 ) ] 
Set Field [ _g_num_temp; "" ]

I needed to parse and reformat a FileMaker-formatted absolute file path into an AppleScript one. Since I'm novice to FileMaker, the only way I found to accomplish that was via a FM Script, although I tried to (and believe it is possible to) use a Custom Function to do the task. It took me about 9 minutes to script it in FileMaker 9.0v3. If you have any ideas or improvements, feel free to use them.

Comments

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

Script Format_FMPath_to_AppleScripPath

Comments

Support this website.

Support this website.